Setting for a Smartsheet -date validation active
We've ran into an issue and we want to know what we are missing....
Our scenario: We have created a new column called "end date". This column is restricted to the column type: date. Even though it is restricted to a date, we did have a user enter in November 31st (which is odd as November only has 30 days).
What are the correct settings that should be selected to ensure only valid or true calendar dates are entered? It seems to be wildly inconsistent. Ideally, we would want an error to appear so they can take action post haste.
Thank you in advance.