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.
Best answer by Troy TessaloneView original
Try using a Formatter > Utilities > Lookup Table step in the Zap: https://zapier.com/help/doc/how-use-formatter-functions#using-the-lookup-table
Similarly in GSheets you can use these formula functions:
Thank you for your response. Works a treat!