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.

Find more posts tagged with

Calendar View

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

Tracking Which Reviewers Have Not Submitted Forms Across Multiple Sheets
Hi Smartsheet Community, I’m looking for some help setting up a way to track reviewer submissions across three different sheets. Here’s the setup: We have three sheets (one for faculty, one for students, and one for scholarships). Each sheet lists applicants, and in each row we assign three Selection Committee (SC) members…
Is there a way to update scaling on Smartsheet Dashboard graphs?
Hi, I'm having an issue where the graphs in the dashboard are auto scaling to the numbers in the table. I was hoping to get a scale of 100 for each of my graphs on my dashboard but there's seem to be no way to update this. Would anyone know how to update this?
Automation problem
Hi, I'm having issues trying to get my automation to function. I have tried it numerous ways and it still doesn't work. Basically, if anything but New York is selected, I want a link email to go out with an additional form I need to fill out. Here is what my workflow looks like: I just cannot figure out what I'm missing…