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 i'm looking to a formula using INDEX and MATCH to refer data from two sheets. i have 2 source sheets sheet: "project" and "Archive projet". in each, there are same columns for projet number and contact name. i would like to refer the contact name in a third sheet with a formula that can find the contact name based on…
I am seeing if I find a match for a value in a multi select column and using the HAS formula. It is returning when the string is found, but also when a string plus additional words is found. For example I am looking for if the color "red" has been selected in the column, but it is also pulling in when "Red Rose" has been…
Hi, I’m trying to set up conditional formatting in my plan and need some help combining two conditions. Scenario: If the T-Start Date is in the past, I want the date to turn red. However, if the Status cell is Green, I want the T-Start Date to show as green instead of red (so the Green status overrides the red formatting).…
