SOLVED

Multiple Conditional Formula

Copper Contributor
Hey guys

Is it possible to have multiple conditions within a Conditional Formula to show/hide a column but only if all conditions are true?

I know you can do it for if either are true but I need both conditions to be true and one is also a number column.

So an example of what I need is:

=If([$Order]==‘Buy’ ll [$Inventory] >=2, ‘true’, ‘false’)

Many thanks.
2 Replies
best response confirmed by LCarroll5554 (Copper Contributor)
Solution

@LCarroll5554 use &&

Many thanks Rob :)

1 best response

Accepted Solutions
best response confirmed by LCarroll5554 (Copper Contributor)