Rollup + IF(SEARCH())

[Lance_Devore]

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 I might be able to achieve this as adding this formula with the Roll Up:

IF(SEARCH({UTM},{Input}){Source})

But it tells me that’s an invalid formula.

Thanks for any help!

[Lance_Devore]

Excellent! It’s working now. The curly quotes were the problem. Thanks so much for your help kuovonne!

[Lance_Devore]

Oh, one last thing for this formula:

If it doesn’t find any of the UTMs in the list, how can I tell it to input “Direct / Organic” as the default?

[kuovonne]

If you want a default if nothing is found, you must use nested ifs, not concatenation.

See this article on nested ifs for more information.