Clear cell of hyperlinks after inserting values by API
Hi, this is probably a really obvious issue, but I know just enough to be dangerous. Here’s the situation:
I am using a Zapier custom webhook to insert a value and URL into a sheet cell to create a hyperlinked cell. So far so good. It all works fine. However, I cannot overwrite that cell with non-hyperlinked data once this first action is complete (the cell updates and sometimes the cell requires a hyperlink and sometimes not).
When I clear the cell manually it then allows a non-hyperlinked value to be added via Zapier. In my naivety I expected there to be a simple API call to clear a cell, which I could add as a step in Zapier prior to adding my non-hyperlinked data but I just cannot find how to do that (I typically rely on finding something someone else has previously done and then getting there by trial and error.). A few other things:
- I tried adding a clear cell native automation in the sheet (the hyperlink cell change is always dependent on another column value), however, even this did not clear the hyperlinked cell when triggered.
- the main Zapier / Smartsheet integration will not overwrite the value either
I feel that clearing a cell or just writing non-hyperlinked value into the cell should be really easy, I just can’t find it anywhere.
Any help would be really appreciate it.
I'm using a cURL format in the Zapier custom webhook to insert the value / URL if that helps