Dynamically Updating Row Information

Advance

I am looking to dynamically update add or delete a row in a sheet based on a checkbox on another sheet. Specifically, we have a sheet that contains all our outstanding balances, and a sheet that contains all our job info. We are looking to have it add a row to our balances sheet when our checkbox isn't checked, and delete it when it is. Does anybody know if its possible to do this?

Andrée Starå

Hi,

It could probably be set up with the help of a third-party solution like Zapier or the Smartsheet API.

Another possible workaround might be to use a report instead and then copy the rows to the other sheet.

Would any of those options work?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting