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.
Good afternoon Smartsheet Fam, I'm trying to create an index formula across 4 sheets to pull into a single sheet. The formula I have tried is: =IFERROR(INDEX({AHM.Client}, MATCH([CU Project ID]@row, {AHMPlan.CUProjectID}, 0)), INDEX({ahmne.client}, MATCH([CU Project ID]@row, {ahmne.cuprojid}, 0)), INDEX({ahmse.client},…
I’m trying to set up a metrics sheet that will feed into a dashboard to show a rolling total over time, but I don’t want future months to display any data. For example, a user will enter values in the right-hand column, and I have a formula that calculates a rolling total in the green column. The green column is what I…
Hello, I am looking to create a summary formula that calculates the projects completed within a given month. From the screenshot, I need a formula that evaluated the 'Status = Posted Live' AND the Actual Completion Date within March 2026. I've been playing with the CountIf formula, but I can't get it to work! Any ideas?
