I’m looking script or formulas or guideline for next task in Google sheets: If checkbox is cheked then value in cell change on “vacation”. If checkbox is unchecked then value in cell go back to previous value. The screenshot visually shows what should happen. I’m newbie and can’t find solution. I will be very grateful if someone helps me in any way. Screenshot
I apologize that I did not accurately state the essence of the question, function "IF" is not suitable since the second condition is dynamic, like this week the specialist works on one schedule (8-11), and next week on a different schedule (it can be any) it would be great if the "if" function worked like this =IF(H1=TRUE,"vacation","return the previous value")