Forum Discussion
AND IF in conditional column
You need to add some paranthesis as and has higher priority than or.
In your case the formula should be built like (a=x or a=y) and (b = m or b = n) etcetera.
Without paranthesis, a=x or a=y and n=m or b=n is equivalent with a=x or (a=y and b=m) or b=n.
So without parenthesis, you can think of all (groups of) ands evaluated first and the ors being in between (groups of) ands.
Thanks MARCEL! I'll give it a shot in a moment!
So, this is what I have and I get an "error" in the new custom column...
if ([Course Name] = "Managing Information" or "Promoting Positive Workplace Behaviour")
and ([#"Organisation / Portfolio"] = "Bio21 Australia Ltd" or "Bio21 Australia Limited"
or "CAVAL" or "Grattan Institute" or "Kendall Hall" or "Melbourne University Publishing Ltd"
or "Nossal Institute Ltd" or "University House" or "Australian National Academy of Music Ltd"
or "Melbourne Theatre Company" or "MU Student Union Ltd") then "Exclude" else "Include"This the error:
Have you tried putting the follwing below?
if ([Course Name] = "Managing Information" or [Course Name = "Promoting Positive Workplace Behaviour")
And then repeat for each instance?
What was the response to this.
I have similar situation for a custom column, i need to have values
if col1=a1 and col2 =a2 then '50'
else col1=b1 and col2=b2 then 100
and so on for 20 values
how to resolve this
