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!
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
