I have a formula column that shows lead time on a job. The counter basically starts when the status changes to ‘working on it’ but continues to count even after the status has changed to ‘done’ which means I don’t get accurate numbers when doing the reporting. I don’t want to use automations as a work around as I don’t have enough automations in my plan for this to be feasible. Thanks.
Hi Alex,
As a workaround, add a “Done Date” column and when you switch the status to “Done”, enter today’s date in it. Then modify your formula to count the number of days between the earliest of the date you’re currently using in the formula and this new date.
What if we could break free of the Formula column? and write formulas that update any type of columns? What if a formula could update multiple columns at once? This is possible with the Advanced Formula Booster app.
Hi Giles, I did actually implement something similar to this before my post was approved so thank you for the suggestion!
1 Like