Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Answered: How to offset a date picker
Hello SC,
I have a staff request for leave smartsheet.
I want to have the date picker 2 weeks forward, so that you cannot select a date within the immediately following 2 weeks.
So, any date up to 2 weeks from now should be greyed out.
Any ideas?
Comments
-
Hi Bevan, it sounds like you are looking for a data validation function which we do not support at this time but I will submit your suggestion for this request. You could add a note to your sheet or the web form (if you use one) that the selected dates must be at least two weeks in advanced.
-
To Travis' you could also add a conditional format.
1. Select column for condition
: it will be the date you want to control
2. Define custom criteria
: is in the next (days) ......14
Then define format (e.g. orange font on a red background) and apply it to the date column where the wrong data is located.
It doesn't fix the issue the royal way you would expect but it increases the awareness and Travis' comment will lead people to a better choice.
-
Thanks,
I'll work around it for now, but yes, data validation is a needed mod.
-
Conditional formatting would be a good indicator of the date being within the next 14 days, but as time progresses, “today” will eventually be within 14 days of whatever date is selected and will trigger the formatting rule. Just something to consider if you choose to use this!
-
I throw in my support of this feature. I want clients submitting a web form to be denied selecting a due date for their project within 4 weeks of the current date. Thanks!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives