Possible to Combine Multiple AND/ORs in an IF Statement

[KellieGardner]

I'm trying to create a text mode column that combines the && operator with the OR operator for multiple options. Anyone know if it's possible to combine them? 

This is what I'm trying to get in the simplest way possible and right now my expression is a little overwhelming. 

If the project status is A, B, OR C AND condition is At Risk OR In Trouble, True Text, False Text

[cverges-medallia]

We do this with our API queries and Fusion conditionals all the time:

A,B,C cicontains project.status && Risk,Trouble cicontains condition

This is a type of trick for both handling boolean logic and array searching.  It's not the best -- I'd much prefer Workfront to have proper boolean condition support, but it's a thing that can be done.

I'm not sure whether Workfront reporting can handle this. 

[KellieGardner · Accepted solution]

Thanks @cverges-medallia - that got my wheels spinning for sure on ideas. Luckily I stumbled upon this old thread: https://experienceleaguecommunities.adobe.com/t5/workfront-questions/syntax-if-statement-with-or-mod... and used it to come up with something a little simpler in terms of ORs, &&s and IFs. Not sure if it's the most simplified but certainly easier to manage and troubleshoot from what I was working with before.

IF({condition}="AR"||{condition}="IT",IFIN({status},"AAA","BBB","CCC","True text","False text for not meeting both criteria")"False text for not meeting condition criteria")

I tried to combine 2 IFIN statements but couldn't get it to work. Not sure if that's an option I'm just missing some formatting?