Tracking how long a record is stuck in the same status

Topic Labels: Formulas
103 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi, does anyone have any tips on how to create a formula that  would calculate the number of days something was in each stage? We track various stage gates for our content: Draft, Proposal, Ready for Production etc. Thanks! 

1 Reply 1

If you're currently storing the date that the stage was reached you can accomplish this with a formula field with a `DATETIME_DIFF()`

If you're not currently storing the date, you're going to need to create one date field per stage and have an automation that triggers when the single select field that tracks the stage gets updated

It'll then have a conditional action to check which stage it's on, and based on the stage it'll update the appropriate date field

With this you'll now know when each piece of content reached a specific stage, and you can use those date fields with the `DATETIME_DIFF` formula field