When I create a new row in Google Sheets, I need to set the ContactID to a randomly generated ID, using this formula: =DEC2HEX(RANDBETWEEN(0, 4294967295), 8)
When I use this formula as the value, what gets recorded in the sheet is the formula instead of the VALUE. Is there a simple way to force it to save the calculated VALUE in the sheet?
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/8247f4d4-868e-4dc7-a7a8-703c4049d701.png)
Thanks!