Setting for a Smartsheet -date validation active

DEW

Hello all!

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.

Genevieve P.

Hi @DEW

Yes you're correct, if you are an Admin or an Owner on the sheet then you can override the "Date Only" setting, however this user should receive a pop-up warning if they were typing in an incorrect date, as you have in your PDF.

If you don't believe this warning is enough for your users, then I would suggest either adjusting this user's permissions to be Editor or use a Form to create your rows and the initial Date. The Form would not allow any text entries because it would see all users as a "Form User", not an Admin.

Cheers,

Genevieve

Genevieve P.

Hi @DEW

I haven't heard of this happening before! The only way that a user could have entered 31st of November is if they typed it in as Text. November 31st isn't an option when selecting a date via the Calendar.

Would you be able to clarify how they entered the date (ex. through a form submission or manually in the sheet)?

Is it possible that the user entered an incorrect date before the column was restricted to Date-Only? (The Activity Log may be able to help you review this.)

Cheers,

Genevieve

DEW

Hello.

We have dependencies off, and you can hard type in any date if you have an Admin Role.

e.g. you can type in 99/99/99. See attached.

We would like to have a sheet, workspace, etc setting that we can hard turn on to not allow bogus dates.

date error in Smartsheets.pdf

Genevieve P.

Hi @DEW

Yes you're correct, if you are an Admin or an Owner on the sheet then you can override the "Date Only" setting, however this user should receive a pop-up warning if they were typing in an incorrect date, as you have in your PDF.

If you don't believe this warning is enough for your users, then I would suggest either adjusting this user's permissions to be Editor or use a Form to create your rows and the initial Date. The Form would not allow any text entries because it would see all users as a "Form User", not an Admin.

Cheers,

Genevieve