Keep users from back-filling completed dates

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?
Comments
-
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!