Automation Trigger/2 Sheets

Trying to explain this..

I have a "master sheet" and a separate "metric sheet" that is used to count items from the "master sheet" so I can make charts for my Dashboard.

The metrics are working as predicted and pulling the data from the "master sheet" to my "metrics sheet".

On the "metrics sheet", I also created Automated workflows that change a designated cell to say either "approved" or "exempt" based on my pulled criteria from the "master sheet".

The problem is that the Automated workflows don't run when I make a change to the "master sheet". The metrics pull over to the "metrics sheet", from my "master sheet" but that does not trigger my workflows.

If I delete a cell from the "metrics sheet" and then paste the formula back in, hit refresh, it then pulls the data from the "master sheet" AND runs the Automation.

Thoughts??

Find more posts tagged with

Accepted answers

Paul Newcome

Formulas with cross sheet references and cell links cannot trigger automations. You have to set them as date/time based triggers with a condition reading your cell linked / formula with cross sheet reference cell(s).

All comments

Paul Newcome

CJ Christie

Thanks! I will give that a try! Much appreciated!

Paul Newcome

Happy to help. 👍️

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.