Failed to do automation when a field changed, and the field is formula based.

Hello fellow, hopefully you can help me out with my question.

so I have a checkbox column that needs to trigger a "Move Row" automation, and the column is a column formula, and it just seems like not functioning as I want.

As you see on the image, Column 2 is the checkbox also a column formula, which needs to trigger the entire row to send to another sheet when checkbox is checked.

thanks!

Find more posts tagged with

Accepted answers

All comments

Thinh Huynh

Hi @Roy Yue ,

Can you do a screenshot of your automation workflow so that we can check it out?

Roy Yue

@Thinh Huynh

Thinh Huynh

There is no wrong with your automation, except for the "copy rows" should be "move rows" as you mentioned, but it's ok if that's what you want.

In case the automation did not function as you want, we may check the formula in Column 2. Can you show it?

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.