Is Automation Workflow can be triggered by Formula resulted change?

Hi there,

I am trying to make a task automation with multiple steps. The idea is I have a master sheet where the task is being copied to from reference sheet (where all tasks in there). The Logic is, when the first task in the master sheet is completed, the second task row will be copied to the master sheet. I have a Status column in the reference sheet same as in the master sheet and put a Join(collect formula to copy the status value in the master sheet. Then I setup a automation workflow wherein the trigger is "when rows are changed" and specific column = "Status" is equal to "Complete". It will copy the next task row.

I tried to simulate it but it not trigger the automation trigger but when manually I manually change the status column, It is working. Is there a way to make it "Formula resulted value" Trigger? Any idea to make it work with human intervention in the reference sheet?

Find more posts tagged with

Formulas

Automations

Accepted answers

All comments

Bassam Khalil

Hi @Julius Benn Sabeniano

Hope you are fine, please try the following workflow

Andrée Starå

Hi @Julius Benn Sabeniano

I hope you're well and safe!

Unfortunately, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

Actions that will automatically modify the sheet cannot be triggered by inbound cell-links or cross-sheet formulas. This includes Request an approval, Move rows, Copy rows, Lock rows, and Unlock rows. For example, if the Status cell on the row is populated by a cell link with a value from another sheet, changes to that cell value through the cell link will not trigger a workflow that locks the row when Status changes to Complete.

As a possible workaround, you could maybe set up a workflow that copies the row from the master to the other sheet(s) and then use that to trigger the workflow.

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 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!

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.