Change cell automation not working

Options
SJTA
SJTA ✭✭✭✭✭

I have an automation to change the value of one cell based on the value in another cell in the same sheet. The change is to occur when triggered.

The source cell value is based on a VLOOKUP formula referencing another sheet.

The cell with the VLOOKUP value changes based on the formula, but the automation to trigger a change in another cell in the same sheet is not working automatically. It only works when I run the Automation for specific cells. I ran the Automation on the entire sheet and it changed all the values in the destination cells in that column.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!