Automation Trigger/2 Sheets
Trying to explain this..
I have a "master sheet" and a separate "metric sheet" that is used to count items from the "master sheet" so I can make charts for my Dashboard.
The metrics are working as predicted and pulling the data from the "master sheet" to my "metrics sheet".
On the "metrics sheet", I also created Automated workflows that change a designated cell to say either "approved" or "exempt" based on my pulled criteria from the "master sheet".
The problem is that the Automated workflows don't run when I make a change to the "master sheet". The metrics pull over to the "metrics sheet", from my "master sheet" but that does not trigger my workflows.
If I delete a cell from the "metrics sheet" and then paste the formula back in, hit refresh, it then pulls the data from the "master sheet" AND runs the Automation.
Thoughts??
Best Answer
-
Formulas with cross sheet references and cell links cannot trigger automations. You have to set them as date/time based triggers with a condition reading your cell linked / formula with cross sheet reference cell(s).
Answers
-
Formulas with cross sheet references and cell links cannot trigger automations. You have to set them as date/time based triggers with a condition reading your cell linked / formula with cross sheet reference cell(s).
-
Thanks! I will give that a try! Much appreciated!
Help Article Resources
Categories
Check out the Formula Handbook template!