COUNTIFS with an OR in it


Hi Community!

I am struggling with the below COUNTIFS formula which basically has to have an OR logic in it...

=IF(Date@row <= TODAY(), COUNTIFS(OR({Status 1}, "Complete", {Status 11}, "N/A"), {Planned End Date 1}, <=Date@row, {Parent Child 1}, "Child"), "")

There must be a syntax error, but I can't find it. Any hints or tips would be great!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!