Update row based on cell value

edited 07/19/22 in API & Developers

I just wanted to ask if this is true:

I am able to insert new rows in the sheet but now I am trying to update existing rows based on the primary column. Basically trying to develop an upsert integration.

Looking at the Update Rows api docs, it seems like I will need to get the Row Id first of all the existing data/rows in the sheet and use that to update? Like there is no way to just update based on the Primary Column value?

Thank you.


  • saurabhmaheshwari

    @Drednaw You can easily achieve this using existing automation workflow - "Change cell value". You can set trigger to primary column and select other columns for which you want to change values. Explore this available workflow and let me know if it suites your use case.


    Saurabh Maheshwari

    Smartsheet Superstar

    Portfolio Lead, TCS