Change cell automation not working
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.
Help Article Resources
Check out the Formula Handbook template!