Is it possible to update data in a Smartsheet report directly using Python?

Is it possible to update data in a Smartsheet report directly using Python, or is it necessary to modify the data in the source sheet to reflect changes in the report.

Answers

  • jmyzk_cloudsmart_jp
    jmyzk_cloudsmart_jp Community Champion

    Hi @Devi

    • Direct Editing in the UI: Users can edit cells directly in a Smartsheet report if the report’s settings and the user’s permissions allow it. These changes automatically update the corresponding cells in the source sheets.
    • Updating via API: Direct API calls to update reports do not exist. So, it would be best to update the source sheets using the API, which will be reflected in the report.
NEW Smartsheet API Documentation - bookmark the updated link! https://developers.smartsheet.com