COUNTIFS + AND / OR

I am trying to count specific information in three columns in my sheet:

  1. Is active - Yes
  2. Multiple 'needs updates' dropdown options
  3. Multiple file types

I tried this:

=countifs([Is Active]:[Is active] "Yes",[Asset Status]:[Asset Status], OR(@cell <> "Needs update - new brand", @cell <>"Needs update - legal changes"),[File Type]:[File Type], OR(@cell <>"PPT", @cell <>"docx"))

But am getting #unparseable

Please can someone advise? Thanks in advance

Rosie

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!