Date field restriction

Best Answer
-
Hi @zealvert
I created this for fun, but you can use the form's logic.
For example, the image below shows 29 days choice for Month=2.
You can test the form using this link. (Smartsheet login required.)
The result will be displayed in the demo sheet below.
Form Logic Image
Columns 29, 30, and 31 have the same label, Day.
I don't think creating logic based on the year to display 28 or 29 for February to deal with leap year is impossible with Smartsheet form, so I added the note above. (This note may be unnecessary as someone born on February 29th should know about this.)
Answers
-
Hi @Andrée Starå and @Dave Rowley
This is indeed a pretty important thing that Smartsheet must resolve asap!
Different dropdowns would not be safe as some people may accidentally choose "31" as day while "FEB" as month! And then there's no way to alert / stop them at the form level itself.
Any other workaround please?
-
Hi @zealvert
I created this for fun, but you can use the form's logic.
For example, the image below shows 29 days choice for Month=2.
You can test the form using this link. (Smartsheet login required.)
The result will be displayed in the demo sheet below.
Form Logic Image
Columns 29, 30, and 31 have the same label, Day.
I don't think creating logic based on the year to display 28 or 29 for February to deal with leap year is impossible with Smartsheet form, so I added the note above. (This note may be unnecessary as someone born on February 29th should know about this.)
-
Thanks @jmyzk_cloudsmart_jp
Appreciate your time and support!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives