Update row based on cell value
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.
Answers
-
@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.
Regards,
Saurabh Maheshwari
Smartsheet Superstar
Portfolio Lead, TCS
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives