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.
Hey Smartsheet Guru’s I have 2 sheets – 1 is capacity and the other is ooto – Sheet 1 – capacity has names and emails and %the first 3 columns and subsequent columns has week to week start date(as text), end date as text and number of days excluding holidays In the OOTO file – it is a simple if someone requests timeoff it…
I have a sheet and I want the checkbox option to appear as checked if the cell in the name column of the same row is one of 133 options- is this possible in a single formula?
Hi there, since yesterday I have noticed that the Sheet Name column links in reports are not taking the user the correct row in the source sheet, as they have always done. There does not seem to be a pattern, sometimes it takes the report user to the top of the source sheet, or to a random row, or the odd time to the…
