#incorrect argument set for a countif statement with multiple references


I'm trying to count check boxes if the % complete is <100. I can COUNTIF the check boxes on their own, but when I add the % complete reference, I get the incorrect argument set error. Any ideas?

Here's the formula: =COUNTIF({Portfolio_Rollup}, 1, {Completion_Percentage}, <100)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!