Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Delete all comments and data of a sheet

Mick Steffan
edited 12/09/19 in Archived 2017 Posts

Hi, how can I delete all comments for all rows in one go for a sheet?

Thanks

Comments

  • Brad Jones
    Brad Jones ✭✭✭✭✭✭

    There is no way to do this for a sheet as a direct operation.

    You could 'save as new' the sheet and have a copy of the sheet with all of the cell formatting and data, but all of the cell history will be gone as well as the notification and sharing settings.

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    For all Comments for all rows (not for sheet level comments), the API can be used to delete them all at once.

    Craig

  • "the API can be used to delete them all at once."



    Means? English?

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Dennis,

    Smartsheet, like most decent software as a service (SaaS) web based systems have an API -- an Application Programming Interface.

    It allows programmers (and thus programs/apps) to utilize SOME of the functionality that you can use from the GUI (graphic user interface). In some cases there are MORE things that you can do via the API, but those are less frequent.

    From the API, I can delete a comment from a row. By extension, I can write a loop that deletes them all. Someone else could do that too.

    If you are interested in paying for such functionality as part of a larger toolset, contact me. My info is in my profile.

    Craig

     

This discussion has been closed.