I'm looking for a solution to a problem that's occurring when using Zapier to update cells in one smartsheet from cells in another smartsheet.
When using the Zapier New Row Update action on a Smartsheet, it's throwing an error: "The app returned "The columnId xxxxxxxx is invalid". This is occurring when trying to update one cell in each of two different rows in a destination smartsheet where we have just completed a Copy Row action from a source smartsheet using Zapier. Additionally, Zapier also reports while stepping through the errored action that there are unused columns in the Zap and once removed, the update will complete and is repeatable on the same sheet. However, it fails the next time an update is attempted on a new destination smartsheet. If you've had this problem before and resolved it, I'd be interested in what you did to fix it.
Best answer by franimalView original