Conditional formatting calendar in cell.
Hi, is there a way to set a minimum date in a drop down calendar in each cell? In my case I have a calendar drop down in a cell where my user can select a date to be completed. However, I would like to set the available dates to no less than 2 weeks. Hope that makes sense.
Comments
-
Hello,
There currently isn't a way to create a date range constraint in a sheet.
One workaround that you might consider is to create an automated update request that will automatically be sent out to the submitter if they put a date in that is less than two weeks in the cell. More on automated update requests here: https://help.smartsheet.com/articles/504779-using-update-requests
-
ewilson,
Did you solve this?
Would you want drop down to update daily?
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 464 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives