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


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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!