Nice intro! Also... I think it's important to note that, even now with only the basic formula field, you can use it with dates too. With dates, the only operator you can use is subtract. But that permits: * Estimated remaining time (Estimate - Actual) * Time to complete (Completed at - Created at) * Time/amount overdue (Completed at - Due date)
Thank you! it was at first fdifficult because the app in deskopt doesn't shows the "+" to add a field... so I was going crazy to get to that point.... I had to do in the online web app. Other thing is that I wanted use the temporizator, but with the default "real time " field it happens what you said.... the total when I do the formula with that field thow me a crazy number with no sense! So, if you know how to use a temporizator in the field that you have created as "time spent" let me know. Otherwise I suppose I have to put it manual and have my temporizator in my phone or other app....... Do you have a solution here? Thanks!
Nice intro! Also...
I think it's important to note that, even now with only the basic formula field, you can use it with dates too. With dates, the only operator you can use is subtract. But that permits:
* Estimated remaining time (Estimate - Actual)
* Time to complete (Completed at - Created at)
* Time/amount overdue (Completed at - Due date)
Good addition. I did not realise only subtract was available!
Thank you! it was at first fdifficult because the app in deskopt doesn't shows the "+" to add a field... so I was going crazy to get to that point.... I had to do in the online web app. Other thing is that I wanted use the temporizator, but with the default "real time " field it happens what you said.... the total when I do the formula with that field thow me a crazy number with no sense! So, if you know how to use a temporizator in the field that you have created as "time spent" let me know. Otherwise I suppose I have to put it manual and have my temporizator in my phone or other app....... Do you have a solution here? Thanks!
Isn't the crazy number a number of minutes when you were maybe expecting hours?
@@asana-ido yes the crazy number doesn't work if we use "real time" that is the default field, only work as a customized field as you did :) .
However I found the way how it works but I won't try it because 1 second is 1 hour hehehe or something like that
you should post on the forum so we could all help you. Richard Sather is the expert on formula maybe he has an idea.