Change Cell Value Automation for rows created in the past

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
    Jeff Reisman ✭✭✭✭✭✭


    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.


    Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

  • mballen
    edited 01/12/22

    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.