Sign in to join the conversation:
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?
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.
Hi all, I'm having some issues with an index-collect formula. I have (3) existing sheets that list a unique project name (text field), as well as a producer assigned to work that project. The producer column in all (3) sheets is set as a contact field. In a separate sheet, I'm trying to auto-populate the producer…
I am currently in business trial version, but i was told it is supposed to allow for full functionality, however when I click Ctr+F my search menu is only a search bar that allows me to only find the string, and it doesn't allow for replacing. Is it me or the F&R functionality rather limited?
I looking to find unique values, in order, and separate them into columns. The "Client Update Date" column will contain dates, not in order and some dates may be duplicated. In the "1st Date Feedback I'm getting the correct date of 12/12/25 with the formula: =MIN([Client Update Date]:[Client Update Date]) In the "2nd Date…
