Dynamically Updating Row Information

Advance
Advance
edited 12/09/19 in API & Developers

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?

Comments

  • Andrée Starå
    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

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.