Change Cell Value Automation for rows created in the past

mballen

Can you use the "change cell value" autopmation to update rows created in the past?

Example. When you create a new status update row on a sheet can the automation change the status of an old status update to "not applicable" or does the automation only interact with newly created rows?

Jeff Reisman

@mballen

Change cell value automation can be triggered by a change to other values in a row. Set your trigger to "When rows are changed," select the field that may cause the trigger to fire, and add a condition block to specify any other conditions that must be met if needed.

Keep in mind, the cell value you want changed can not be the same as the field that causes the trigger to fire.

mballen

Hey @Jeff Reisman,

Just to clarify, it sounds like you are saying that "change cell value" automation is triggered to values in a specific row and it does NOT have the ability to edit a different row.

Exp. Row B has a value change and I can automated an update in Row B but it WILL NOT automate an update in Row A.