Help

FIND multiple text in a cell

Topic Labels: Formulas
780 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Joel1
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi, I can’t find a solution to this:

I have a Lookup field that consists of multiple text values separated by a comma. I’m adding a seperate column to indicate the status based of that Lookup field which should contain of 3 possible values:

  1. IF FIND “Paid” = Completed
  2. IF FIND “Pending” = Pending
  3. IF FIND AND “Pending” & “Completed” = Partially Completed

Now it seems that AND doesn’t work in combination with FIND.

Has anyone found a solution for this?

3 Replies 3

Hey Joel, think we’re getting hit by the way lookups are formatted

Check this base out

Screenshot 2022-07-01 at 11.54.22 AM

FIND works as expected for linked fields and rollup fields but not for lookups it seems

The rollup field worked for me! Thank’s for your support :pray: :blush:

@Adam_TheTimeSavingCo @Joel1

FIND works with lookup fields, but you need to turn the lookup field into a string by adding & "" after the field name like this:

{Lookup Field} & ""

So, to find something in a Lookup field, it would look like this:

FIND("phrase to look for", {Lookup Field} & "")