Sheet automation loop

I am looking to understand how to break a loop so I can fix something. We are trying to remove columns from a sheet, but the automations keep replacing them on connected sheets before we can get them deleted on the other side. Is there a way to export a configuration so we can see all of the connected sheets? Also, how can we modify each one, so they don't keep trying to "fix" the other sheet before we modify the one up/down stream?

Answers

  • Adam Murphy
    Adam Murphy ✭✭✭✭✭✭

    The only way for automation to add a column as far as I am aware is through an automation to either move or copy a row to another sheet (which will add all columns from source sheet into the destination sheet unless exact name match already exists). You would need to look at all the sheets in that workspace that could be sending rows to the sheet you are trying to remove a column from and you will need to remove that column from all the source sheets, then remove from the target sheet. Hope that makes sense.

  • Thank you, Is there any easy way to see what All of the source sheets are so we don't miss one?

  • Humashankar
    Humashankar ✭✭✭✭✭

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!