Column Formula Changes - Change Cell Value

A Rose
A Rose ✭✭✭✭✭
edited 02/22/22 in Formulas and Functions

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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!