Is there a way to Force a Date or Time?


I am trying to have some date fields auto-populate based on some restrictions. Date Columns 2, 3 and 4 would be dependent on Date column 1.

For example:

An Inspection must always occur at least 2 days after Work Start. If I enter Work Start to be 1/20/2020, I want the Inspection Date to auto-populate to 1/22/2020. Inspection Date could be adjusted for a later date, but not an earlier date.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!