Copy to another sheet workflow.

Katherine Britt

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.

Razetto

@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.

Humashankar

Use a combination of smartsheet automation feature with cross sheet triggering automation actions.

It will take some time for me to try this use case to confirm the solution works at my end

However it is an interesting problem statement to work with - Thanks for sharing

Razetto

@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.

Katherine Britt

@Razetto Thank you! Your solution worked.