Can a workflow be designed to reference a data field in another sheet?
I am playing with the idea of creating a master reference sheet and using that as a cross reference for another. For example, I would have a master list of all leaders by geography. I am curious if I can devise a workflow based on selection of a geography (ie: USA) in another sheet, to send a message to the corresponding leader noted as a Contact in the master reference sheet.
Thoughts?
Thanks.
Bill
Comments
-
Hi William,
Yes, you can.
You’d cross-sheet formulas and VLOOKUP or INDEX/MATCH to set it up.
Would that work?
I hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Seems totally doable. I would use a VLOOKUP to cross reference your geography column in the main sheet with a list of geography and contacts. Then you could return the appropriate contact to your other sheet and fire an automation which sends an email or alert to the contact.
Here is more on using VLookup with a cross sheet reference:
-
I will spend some time playing and come back with what I learn. Thanks.
-
@William Lafferty Excellent!
Let us know if you have any questions.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives