Hello,
I’m writing a formula to tell me the DMA region of a client based on a list of zip codes. Here’s my formula so far:
IF({Zip Code}=‘34471’,‘Tampa’,IF({Zip Code}=‘32703’,‘Orlando’,‘Other’))
I just need to know how to turn ‘34471’ and ‘32703’ int...
Hello,
Here’s my base:
I’m using a Roll Up to see if the URL in “Leads” table includes the UTM in “Inputs” table. If it does, I want it to add the corresponding “Source” from the “Inputs” table as the “Referral Source” in the “Leads table”
I thought...
Hello.
I have 2 tables in one base. One is called “leads” and one is called “Inputs.” (I’d like to add screenshots of them, but it says images are not allowed in posts)
“Inputs” has 2 columns:
Column A: “UTM” - 43 rows of different UTM strings
Column...
Alternatively, but not ideally, I could skip referencing another table and just write everything into a formula like this:
IF(SEARCH("?utm_source=youtube&utm_medium=video”,{Input}),”YouTube”,
IF(SEARCH(“?utm_source=google&utm_medium=cpc&utm_term=tamp...
Yes, my “Input” field in Leads is linked to the “UTM” field in Inputs in a many-to-many relationship. Its an old screenshot so maybe I hadn’t done that before I took the screenshot.
Maybe I should skip the Roll Up and just do a formula only?
In Excel...
