Help with formula for multiple criteria
Options

dakissee108951
βββ
=COUNTIF([Academic Yr]:[Academic Yr], OR(@cell = "Fall 2019", @cell = "Prior to Fall 2019"), Status:Status, "Active")
Best Answer
-
Happy to help! ποΈ
If it does not work, feel free to revisit. If it does work, please remember to mark the most appropriate answer as the "Accepted Answer" so that others know a solution was found.
Answers
-
Try changing it to a COUNTIFS (with the S on the end).
=COUNTIFS([Academic Yr]:[Academic Yr], OR(@cell = "Fall 2019", @cell = "Prior to Fall 2019"), Status:Status, "Active")
-
Thank you. I will give that a try.
-
Happy to help! ποΈ
If it does not work, feel free to revisit. If it does work, please remember to mark the most appropriate answer as the "Accepted Answer" so that others know a solution was found.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!