Conditional formatting calendar in cell.

ewilson34796

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.

Shaine Greenwood

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

J. Craig Williams

ewilson,

Did you solve this?

Would you want drop down to update daily?

Craig