Formula to calculate number of days in process
I am looking to create a formula that will stop calculating once the checked box column is marked. The formula I am using to count the days is =TODAY() - [Date added]@row.
I would like it to stop counting once the box is checked but not revert to blank. As an example if I checked the box I would like it to stay at 97 and stop counting. Any suggestions?
Help Article Resources
Check out the Formula Handbook template!