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.

  • Mike WildayMike Wilday ✭✭✭✭✭

    Hmmm. The challenge is that you have to unlock the column not the row. Row unlock locks and unlocks an entire row. You would have to apply that to the entire column. Perhaps a better choice would be to add a formula in the cell so that editors can't edit it. Then use the delete a cell's value workflow.


  • Neil WatsonNeil Watson ✭✭✭✭✭

    @Tim Dollmeyer a possible workaround is to use the "Change Cell Value" automation with a condition, that overwrites the "locked cell" with an error message unless the "condition cell" is completed? And second automation to notify if this error message is triggered.

  • Tim DollmeyerTim Dollmeyer ✭✭✭✭

    Thanks for your help! I set up a workflow that deletes any input in the status cell if the diagnosis cell is empty. Sneaky, but it works.

  • Mike WildayMike Wilday ✭✭✭✭✭

    @Tim Dollmeyer Awesome. I am glad I could help. Where there's a will there's a way! #creativeSolution for the win!

Sign In or Register to comment.