Workflow actions not being triggered by changing linked cell

I tried everything just the other day even going so far as creating a ticket to complain but I wasn't able to get anything to work by using a cross reference sheet. I tried using the change cell value whenever my index/match updated but it wouldn't do anything until I went into the sheet and manually ran the automation. I tried using modified dates as well no luck, the only option was to set up time based automations which didn't meet my need so I considered it a lost cause. If you could get it to lock and unlock that might refresh the sheet in the background triggering the automation but Lock and unlock also don't work with cross reference sheets so the dev's clearly thought of everything.

The only workaround I could think of that I didn't try would be to copy a row into the sheet when the other sheet is updated, this should trigger the automation to run then use another automation to delete it or move it to a deleting sheet. This may be a workaround but it would add a random row to your sheet for the sole purpose of triggering an automation which is just ridiculous.

Hi @shrav919

I hope you're well and safe!

Try using a cross-sheet formula instead.

I recently developed a client solution for RFQs where we use a checkbox to trigger it for each vendor, and then we have a cross-sheet formula checking boxes in the specific vendor's sheet that triggers the workflow for an update request, and it works.

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

@Andrée Starå your solution is also not working for me - can you give more details? It doesn't seem to matter what kind of workaround I put in place (a checkbox or formula that references the INDEX MATCH cell), if the modified by is a cell link, then it won't trigger a workflow.