Skip to main content

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?

Thank you for your response. Works a treat!


@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


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