I’m collecting a user’s street address and pumping it to my Sheet via webhook.
In the Web UI I want to automate, there’s a dropdown for street suffixes (ST, RD, PL, BLVD, etc). There’s 20+ potential values and I would prefer not to have to create that many IF logic statements. Ideally, I can make it select the value from the dropdown that matches the value from a cell.
What advice would you have for me?