Best answer

How do I convert Google Sheets number in cell to text

  • 29 September 2021
  • 3 replies
  • 65 views

Userlevel 1

Hi, I have rows in a Google Worksheet being created and populated from a webform. One of the columns populates as a number, i.e. 3 or 6 for example. I need the numeric value for another Zapier friendly app to utilize. For my Zap workflow however I want to populate a custom field in a 3rd party Zapier friendly app. Not as a numeric value but a text field where say 3 = Bronze and 6 = Gold. 

I was looking for a router function where IF cell = 3 then Bronze and IF cell = 6 then Gold. I would then grab the output value and populate the field in the 3rd part app further down the workflow with a text field.

 

Any ideas?

icon

Best answer by Troy Tessalone 29 September 2021, 01:27

View original

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

3 replies

Userlevel 7
Badge +14

Hi @troyc 

Try using a Formatter > Utilities > Lookup Table step in the Zap: https://zapier.com/help/doc/how-use-formatter-functions#using-the-lookup-table

Userlevel 7
Badge +14

@troyc 

Similarly in GSheets you can use these formula functions:

VLOOKUP: https://support.google.com/docs/answer/3093318?hl=en

QUERY: https://support.google.com/docs/answer/3093343?hl=en

ARRAYFORMULA: https://support.google.com/docs/answer/3093275?hl=en

Userlevel 1

Thank you for your response. Works a treat!