Skip to main content

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?

 

 

Thanks!

Hi @jbuttimer 

You can use a formatter > spreadsheet-style formula to generate the value in Zapier and then just map the value to Google Sheet.

 

Link: https://zapier.com/help/create/format/understand-spreadsheet-style-formula-functions