Is there a formula for checking a box if date in another column is changed?

Sara Ross

I have a checkbox column that I've set up a "Change Cell Value" automation to check the box when the date in another column (Due Date column) is changed. However, I would like the box to be checked only if the change in date is greater than the prior date... as a way to indicate an extension has been granted. Is there a way to set that parameter? If not with the automation tool, would there possibly be a way utilizing a formula?

Andrée Starå

Hi @Sara Ross

I hope you're well and safe!

Please have a look at my post below with a method I developed. You could combine it with another helper column that checks if the date is later or not and then use the change a cell action in a workflow to check the box.

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sara Ross

Thanks for the suggestion. I was able to create another sheet (I called it Feeder Sheet) to receive a copy of the row when the Due Date changes on the original sheet, but am having difficulty in the specific steps to take after that point.

Andrée Starå

@Sara Ross

Happy to help!

I'd be happy to share an example. 

Please send me an email at andree@workbold.com, and I'll share it with you.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!