Locking Cell - with Conditions

edited 12/09/19 in Formulas and Functions

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!