Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

"Nested" if struggle

I'm struggling to create an If with a desired end result of "Yes" or "No" We have 4 categories to test for in a text field, "" (i.e. blank) [Fred Flintstone: 31/03/2022] a character string that c...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Anonymous Try:

    RejectedLine = IF(TableName[TextField]="" ||
                SEARCH("]",TableName[TextField],,0)=LEN(TableName[TextField]) ||
                CONTAINSSTRING(TableName[TextField],"deleted or reassigned"),
                "No","Yes")
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous Try:

RejectedLine = IF(TableName[TextField]="" ||
                SEARCH("]",TableName[TextField],,0)=LEN(TableName[TextField]) ||
                CONTAINSSTRING(TableName[TextField],"deleted or reassigned"),
                "No","Yes")