Automation on Sheet One from a row that is linked from Sheet Two
Hi there,
I have two sheets for a company I work for. One sheet (called Permitting) is used to track permitting statuses for different jobs we have, as we have to deal with dozens of different townships to get approval for installation, which takes weeks to months. The other sheet (called Job List), is our general job status tracker, that ensures we have customer approval and is going through the fabrication process. I have a column from the permitting sheet called "Permit Status" that is linked to the job list sheet. I wanted to set up an automation that, when the permit status on the permit sheet is changed to "verbal approval", which would then show on the job list sheet as "verbal approval", send a notification to our boss requesting him to double check the job and attachments and then approve or deny it, which (if approved) would then send a notification to our scheduler that the job is ready for production. However, when I set up that automation, it doesn't seem to work because the change isn't actually happening on the job list sheet, but the permit sheet. And I want to attach the most recent attachments from the job list sheet that aren't on the permit sheet, so setting up the automation on the permit sheet wouldn't seem to work. Anyone know of a workaround?
One thing I tried was to set up an automation where, if on the job list the permit status is showing as verbal approval and the row is modified, then it will send the automation. But days or weeks could go by without any other column changing for that specific row, and I don't want there to be a long delay in notifying the boss that the job is ready for review.
Any advice would be greatly appreciated.
Answers
-
Hi @NorrisH
I hope you're well and safe!
This might help.
Please have a look at my post below with a method I developed to update the sheet(s) daily (could be modified to hours).
More info:
Would 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 or/and as the accepted answer. 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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives