Locking Cell - with Conditions

Terrapin69

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

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