Copy to another sheet workflow.

Options

I need an automation to copy rows from Sheet A to Sheet B based on a change in value on Sheet C. I can't figure out how to get the automation to work since I am using a cross sheet formula to see the changed value on sheet C. The rows may need to be copied several times a day.

I am running into problem because actions that automatically modify the sheet can't be triggered formulas that refer to another cell with a cross sheet formula.

Best Answer

  • Razetto
    Razetto ✭✭✭✭✭✭
    Answer ✓
    Options

    @Katherine Britt A work around is using DataMesh, so whenever the change happens in C it will be updated in A next time the DMesh config runs and that new value change triggers the automation to move the row to B. The way to link A and C is by having unique number or id.

Answers