Question

How to set Google Sheets column to be the formula value instead of the formula?

  • 6 December 2021
  • 1 reply
  • 80 views

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!


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +9

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