Answered: How to offset a date picker

Bevan

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?

Travis

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. 

Charles DESCOTES

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.

Bevan

Thanks,

I'll work around it for now, but yes, data validation is a needed mod.

Travis

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!  

Stewart Grinton

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!