Lock a Cell Unless Conditions Met

07/22/21
Answered - Pending Review

I'm trying to keep users from updating a cell until another cell is filled in. I tried using a workflow, but it's not working. Anyone have any experience with this?

Answers

  • Mike WildayMike Wilday ✭✭✭✭✭

    Have you tried refreshing your sheet after the initial column is filled in? Sometimes automation don't fire until the data is saved. Let me know if that helps or not, and I can help you dig into it more.

  • Tim DollmeyerTim Dollmeyer ✭✭✭✭

    Thanks for your response!!

    Yes, I always save and refresh a few times (too impatient to wait for the system).

    Here's how I have it set up:

    I have a column called "Tech Status" that is locked. I have two workflows set up: 1) enter a value "Ready for Status" when anything changes in a column called "Tech Diagnosis". 2) Unlock the row "Tech Status" when "Ready for Status" is entered.

    The first workflow is working, the unlock one is not.

Sign In or Register to comment.