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

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…