Prevent non-existent dates
![Paul G.](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Is there a way to prevent non-existent dates from being entered into a date formatted column?
I have found individuals have entered dates that do not exist (ex. 4/31/22).
Thank you.
Pau
Best Answer
-
I tested it out on a sheet just now. If I change the date column properties to have "Restrict to dates only" selected then it didn't like me entering 04/31/22. That should fix it I believe. Since you're the sheet owner (I'm guessing), then you'll get a warning which will allow you to enter a non-date but others won't get the warning. They just won't be allowed to enter non-dates or dates such as 04/31/22 or 02/30/22.
Answers
-
I tested it out on a sheet just now. If I change the date column properties to have "Restrict to dates only" selected then it didn't like me entering 04/31/22. That should fix it I believe. Since you're the sheet owner (I'm guessing), then you'll get a warning which will allow you to enter a non-date but others won't get the warning. They just won't be allowed to enter non-dates or dates such as 04/31/22 or 02/30/22.
-
Thank you @Mike TV for the answer.
Being new to Smartsheet I had not noticed this setting.
Paul
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!