stop counting outstanding days when task is complete
Hello All,
I am using this formula =TODAY() - [Date Field Checked]3 but I need to stop this count when the item is complete.
Could someone please help out?
Comments
-
How does the user signify complete? Check box, status text, or % Complete.
By stop the count, do you want it to return blank when complete or keep the last value?
Smartsheet does not do the second one -- I use Zapier for that if I have to. Or the API.
If just blank then
Assuming you have a checkbox in a column name Done
=IF(Done@row,"",TODAY() - [Date Field Checked]@row)
I hope this helps.
Craig
-
Hi Craig,
Thank you. I would like it to just store the value. They check "Partial- holding for rework" or "complete". As soon as complete is checked I just want it to hold.
-
Smartsheet won't do that.
It needs a toggle function or a set-reset function, which is does not have.
If this is a single sheet or a small fixed set of sheets, I would use Zapier.
What you are looking for an accumulator, not a counter. Now that I think about it, the API might be easier to implement such a thing.
Craig
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!