Hi everyone,
I have an and or statement that looks at one column, and then once it spots "flagship" it look for any of the following "or's"
I am at a loss trying to get it to work.
Any help would be appreciated(:
I would recommend add "(" after the "and".
You have an extra ending parentheses after "Flagship Allowed"! So either delete that parentheses or add an extra one earlier on in your formula
Thanks for the quick reply!
I get this: It was this before so i added the extra one and it got me to the previous picture.
Brings me back to this:(
Oh, you can’t list out multiple words in a contains statement. So you’ll either have to separate them out or use maybe NOT IN instead.
if you copy paste the formula here, we can help more directly
Direct formula:
f contains([Lounge Type],"Flagship")and ! Contains([FFP Tier], "Sapphire", "Emerald")
or ! Contains([Tier], "ex-platinum", "Platinum","platinum pro", "conciergekey")
or ! contains([Flagaship Allowed?], "Flagship Allowed")
then "x" else "" endif
Just posted it
IF contains([Lounge Type],"Flagship")and !Contains([FFP Tier], "Sapphire")
or !Contains([FFP Tier], "Emerald")
or !Contains([Tier], "ex-platinum")
or !Contains([Tier], "Platinum")
or !Contains([Tier], "platinum pro")
or !Contains([Tier], "conciergekey")
This Formula should at least get rid of the red underline - I don't know if it will accomplish what you want though. For example, you might be better off using AND
and !Contains([FFP Tier], "Emerald")
and !Contains([Tier], "ex-platinum")
and !Contains([Tier], "Platinum")
and !Contains([Tier], "platinum pro")
and !Contains([Tier], "conciergekey")
and ! contains([Flagaship Allowed?], "Flagship Allowed")
Finally works thanks!
But, I need the formula to be "doing" this:
If Lounge type says "Flagship"
And one of the following or is not met put an "x".
Im getting the "x" on every row.
Try out the edited second formula!
Appreciate the help!
WIll tinker with it.
Thanks again
Happy to help! When you resolve it, please accept one or more of the responses as a solution so the thread closes 😊
