Updating a Date Column after another cell is updated.


I am trying to have a Date Column update with today's date when a single select option is chosen. I don't want to use the system update date column because that will get updated whenever any cell is selected.

For example: I have a single selection column with several options: Estimating Complete, Quote Sent, and Sale. I have a three date columns that would create or update to today's date whenever their respective choice was selected.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!