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!

Find more posts tagged with

Formulas

Automations

Accepted answers

Dale Murphy

@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.

All comments

Dale Murphy

@Dakota Haeffner We have numerous workflows running on sheets that have cross sheet links; not sure that is the issue.

Dakota Haeffner

@Dale Murphy Good idea Dale, Thank you I'll set that up!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.