Column Formula Changes - Change Cell Value

Hi Community,

I have a column that contains a column-formula it has 3 options/ratings: "1-Great", "2-Not Good", "3-Bad",

I set up an Automation that if it changes to 2 or 3 it should check a box in another checkbox column, but this is not working.

I have another Automation that if it changes to a 2 or 3 it alerts soneone, and this is working just fine.

Any ideas?

(The default column settings for the column with the column-formula is a dropdown with above options, and the original column where the VLOOKUP is taking the infomation is also a dropdown with same options.)

Thank you!

Find more posts tagged with

Formulas

Automations

Accepted answers

All comments

Sandhiya07

Hi @A Rose ,

Hope you are doing Good.

If it's not a issue, could you please share us the Screenshot of automation you have built. Hope that helps us to find better solution and understanding.

Thanks,

Sandhiya P

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.