Please help: COUNTIF formula with embedded OR statement

Options
jasmine.pena
jasmine.pena ✭✭✭✭
edited 03/29/24 in Formulas and Functions

Can someone help me work out this formula? I am needing to count the items within the portfolio summary who status does not read "Complete" or "On Hold". The current formula I am using is pasted below and is still counting the on hold items.

=COUNTIF({Portfolio Summary | Status}, OR(@cell <> "Complete", @cell <> "On Hold"))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!