Formula construction

jgneely72151
jgneely72151 ✭✭✭✭✭✭
edited 12/08/21 in Formulas and Functions

So I'm trying to count the number of records that are non-compliant in status column that does not include the number revoked in Flagged column. I'm getting "INVALID" result. Can you tell me where I went wrong?

=COUNTIFS({Status}, "non-compliant", {Flagged,<>"revoked"})

There are some blanks in the flagged column which is OK. I want everything counted, even the blanks except "revoked".

Now that I think about it, maybe this formula should include isblank???...πŸ€” I don't know, it gets so confusing to me.

Any help is greatly appreciated!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!