How do I convert Google Sheets number in cell to text

Question

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?

Troy Tessalone · Accepted Answer

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

Troy Tessalone · Answer

@troycSimilarly in GSheets you can use these formula functions:VLOOKUP: https://support.google.com/docs/answer/3093318?hl=enQUERY: https://support.google.com/docs/answer/3093343?hl=enARRAYFORMULA: https://support.google.com/docs/answer/3093275?hl=en

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded