Help

Formula issue: duration field

Topic Labels: Dates & Timezones
Solved
Jump to Solution
5765 10
cancel
Showing results for 
Search instead for 
Did you mean: 
Emily_Gonzales
5 - Automation Enthusiast
5 - Automation Enthusiast

Using the solution i found in a similar thread but this formula keeps returning an error. I can’t figure out where it has gone awry. The Total Time field is field type: duration. The others are multiple select. Without the DATETIME FORMAT i dont get an error but get the time as raw seconds and that isn’t helpful. Help! what i am doing wrong?

{Team member}&" -"&{Type of Service}&" - "& DATETIME_FORMAT({Total Time},‘h:mm’)

10 Replies 10

Did the method in this thread about using formulas to identify duplicates not work for you? It was a very resource intensive method, and doesn’t scale. Its main advantages was that it could be used on the free plan.