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!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 61.8K Get Help
- 335 Global Discussions
- 193 Industry Talk
- 426 Announcements
- 4.3K Ideas & Feature Requests
- 130 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 447 Show & Tell
- 27 Member Spotlight
- 1 SmartStories
- 280 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!