Delete all comments and data of a sheet

Mick Steffan

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

Thanks

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

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

Craig

Dennis Wierzbicki

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



Means? English?

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