I’m looking to create a calculated field that shows me the number of days it takes to complete a record. The start date should be when the record is created, and the end date will be based on a dropdown field’s value (e.g. when the status field is set to “complete”).
My thinking is that I need to create three formula fields:
- The date when a record is created (I’ve managed to achieve this part).
- The date when the status dropdown field is set to “complete”.
- The difference between the two dates in days (I’ve managed to achieve this part).
So basically I’m missing how to create the 2nd field.
Am I approaching this the wrong way? Is there a better way to show this report that doesn’t involve using an app add-on?