Multiple conditions IF statements

Question

I want to get a result of "Ready for QA" for a few conditions being true. Here are the IF statements that I wrote for each condition, but I don't know how to combine them. If all of these conditions are true, I want to populate the column with the words "Ready for QA"

IF({name}="Upload instructor materials"&&{percentComplete}<100

IF({name}="Upload participant materials"&&{percentComplete}<100

IF({name}="Set up Conferences i/o session (settings, polling)"&&{percentComplete}<100

skyehansen · Accepted Answer

You could give IFIN a try. The syntax is in the link below. https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/calculated-custom-data/calculated-data-expressions

Sign up

Login with SSO

Login to the community

Login with SSO