Keep users from back-filling completed dates

7eaven

 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?

Mike Wilday

No this is not currently possible. You can always check a cell's history by right-clicking on the cell to see the actual date that they entered it. It would be great to have some sort of time stamping feature. But alas, it does not exist. 

https://help.smartsheet.com/articles/518314-viewing-cell-history