Expand my Community achievements bar.

Alternative to AND in a Calculated Custom Operator

Avatar

Community user
In MS Excel, I am able to compare 2-to-many logical statements using the AND operator. I am trying to do the same thing in Workfront using a Calculated field. But AND is not available. What is the alternative? Example: If = AND If = THEN "TRUE"
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 10

For anyone looking for a solution to this...here's how to include nested AND within an IF on custom calculated field:

 

IF(MONTH({plannedStartDate})=MONTH($$NOW)&&MONTH({plannedCompletionDate})=MONTH($$NOW)&&{revenueType}!="Not Billable",{workRequired}/60,"")
 
Use &&