Keep users from back-filling completed dates

edited 12/09/19 in Formulas and Functions

 is there a way to set a date column so that only the current date can be entered?

Right now we have START, DUE AND COMPLETED DATE columns. The problem is that people are back-filling the completed date, for example putting in a 3/1 completed date on 4/1.

We would like to get people to fill in the completed date on the date is completed, but if they do not, that they are prevented from back-filling, and can only enter today’s date in the completed column.

Is there a way to do this?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!