Get Row from Several Sheets
Hi All,
I was curious if anyone has a scenario/sample willing to share where trigger event is when any row across several sheets.
I've seen similar workflows built in Power Automate and in Zapier, but nothing specific in Bridge yet. I'm assuming there's some things to consider around the rate limits if it's monitoring all sheets in the account, so would be curious on some tricks/best practices to avoid any workflow delays.
Thanks!
Answers
-
You can setup multiple triggers for one workflow. So, it's not elegant but you could setup a trigger for each sheet that you're watching, and have all those triggers point to the same workflow.
Another option, depending on how your data is setup, would be to setup a "trigger sheet" that either uses formulas to watch for changes in other sheets, or setup the other sheets to push rows to the "trigger sheet" when changed. It might get pretty unwieldy depending on how many sheets and rows you're talking about, but it would give you one sheet to trigger one trigger in Bridge.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives