I can't figure out how to do this formula and I've been searching for it in community.
I've tried the following:
=COUNTIFS(Portfolio Rollups Range 1, "Corp IT",AND({Portfolio Rollups Range 8},="In Progress",{Portfolio Rollups Range 8},="Complete")
This one returns unparsable
=COUNTIFS({Portfolio Rollups Range 4}, "Yellow", {Portfolio Rollups Range 8}, "In Progress", {Portfolio Rollups Range 8}, "Completed", {Portfolio Rollups Range 1}, "Commercial Ops")
Returns a value but the value is incorrect.