Prevent non-existent dates
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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!