Allow cell to cell dependencies to prevent cell modifications

benisnotfunny

In my scenario, I need someone to take a sequence of steps in order by changing different cells. Without being aware of it, some users are skipping to a later step that looks 'obvious' to them and missing a previous step. They mark an action as complete, while another field is blank and makes it look like the request wasn't touched. I'd like to make the ability to modify Cell X dependent on the status of Cell Y. In my scenario, a user could not modify Cell X if Cell Y was blank.

I have managed this right now by several automations that fix the empty Cell Y when Cell X is modified, but it's a cumbersome conditional pathing for every iteration AND I needed to add new conditions in my automated notifications.