🎶 Finally it happened to me🎶 - 5 Top Use Cases For The New Formula Field (so glad it is finally here!)

[Richard_Sather]

Hi @anon2656139 , now that the new Advanced Editor is available, you can achieve the value of task durations in hours by using this formula which you can copy paste into the advanced editor:
( ( [[$DUE_DATE]] - [[$STARTED_AT]] ) + 0 ) / 60
or this one if you want without decimals:
( ( [[$DUE_DATE]] - [[$STARTED_AT]] ) / 1440 + 1 ) * 24

You can also have a look at my recent post where you can do all sorts of things with the new Advanced Editor, here:

12 Formulas to get you started with the new Advanced Editor

Hi everyone! I hope you are all excited about the recent roll out of the Advanced Editor for Formula fields as I recently announced here. That post includes a video where I had the chance to showcase various use cases, so I thought I’d create this post to share more details on how I built them, which will hopefully inspire you while you try out the Advanced Editor for Formula fields (rolling out on Business and Enterprise tiers). 1. Task Duration: Prerequisites: Start & Due …