Locking Cell - with Conditions

Is there any way to lock/restrict a cell that asks users to choose a date? For example, I want users to be able to choose a date earlier than what is "listed" in the cell but be unable to choose a date after the date that is listed.

If the cell reads 9/1/2019, the user should be able to change the date to 8/30/19 but NOT to 9/2/19

Find more posts tagged with

Sheets

Formulas

Comments

Andrée Starå

Hi,

Unfortunately, it's not possible at the moment to restrict the dates, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

As a workaround, you could maybe have a cell show a message that they should select another date or something similar.

Would that work?

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Terrapin69

That may work - what formula could I use in the cell to achieve this?

L_123

=if(and(date@row > today - 2, date@row < Today + 2,"","Pick a date inside the range or I will find you")

This formula will check if the value in the "Date" column in the same row as the formula is greater than 2 days prior to the current date, and less than 2 days in the future. If the date selected is outside of the range, the cell will show "Pick a date inside the range or I will find you", otherwise the cell will be blank.

Andrée Starå

Happy to help!

I saw that you got it answered already!

Let me know if I can help with anything else!

Have a fantastic weekend

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

How to split contents from a cell from a smartsheet into another smartsheet
I need to extract and split the contents of a cell in a Smartsheet into three separate columns to a new smartsheet. The cell entries are originally submitted through a form.
Information in a form populates specific cell.
Hello, Just investigating an idea. I'm building a staff register sheet. I'm curious to know if its possible to populate specific cells by the answers given in a form? So if, in a form, a staff member gives their name, the date and that they will be on leave, sick, training ect. Once the form is submitted, it will populate…
A multiple SUMIF function
My current formula is below. I would like to update this so that I only get a total of those that have been Quoted and have a timeframe data of 2025. How do I add this extra filter into the formula? =SUMIF(Status:Status, "Quoted", [Est. GP]:[Est. GP])