Using Countif to count Often and Very Often,

steinkj ✭✭✭✭
edited 06/27/23 in Formulas and Functions

however I can't get it to work the Often is also counting the Very Often:

=COUNTIF([Tools & Resources (SE-2)]8:[Tools & Resources (SE-2)]12, HAS("Often", @cell), NOT(HAS("Very", @cell)))

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!