Column Formula Changes - Change Cell Value

A Rose

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!

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