Automations and Cell Linking
Hello,
I've read in a few past threads that automations will not work with Cell Linking. For example, I have a column that uses VLOOKUP to pull a Status from another sheet that is imported via Data Shuttle on a daily basis. I wanted to have the rows moved to my completed sheet anytime the Status changes to Closed. It would seem that it doesn't recognize that it is closed.
Has anyone found a work around to this? I tried a helper column that displays whatever is in that cell as text but it doesn't seem to be working. Thanks!
Best Answer
-
@Dakota Haeffner We have numerous workflows running on sheets that have cross sheet links; not sure that is the issue.
Regardless, my goto work-around workflow approach when "row adds or changes" doesn't seem reliable is to run a workflow on a time-based trigger. If you know when the Data Shuttle import occurs, run a workflow an hour later that checks status and does your move.
dm
Answers
-
@Dakota Haeffner We have numerous workflows running on sheets that have cross sheet links; not sure that is the issue.
Regardless, my goto work-around workflow approach when "row adds or changes" doesn't seem reliable is to run a workflow on a time-based trigger. If you know when the Data Shuttle import occurs, run a workflow an hour later that checks status and does your move.
dm
-
@Dale Murphy Good idea Dale, Thank you I'll set that up!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!