Countifs, is not blank question??

I have a formula that counts distinct entry's in a column "IFS Service Location" (to avoid counting duplicates) and in the "booking status" column had a status of "ready to book". .

=COUNT(DISTINCT(COLLECT({IFS Service Location ID}, {Booking Status}, "Ready to Book")))


I would like to change the citerion_range1 to a different column called "incentive date" and count the non blank cells in that column.

=COUNTIFS(DISTINCT(COLLECT({IFS Service Location ID}, {Incentive Date}, <>"" )))) (unparseable)

It does not work yet. Am I on the right track? Any suggestion would be appreciated.

Answers

  • TDobson
    TDobson ✭✭

    Here is a snipit of the 2 columns. The Incentive Date column is a date column.


  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @TDobson

    It looks like you just have an extra closing parentheses!

    =COUNT(DISTINCT(COLLECT({IFS Service Location ID}, {Incentive Date}, <>"" )))

    You only need three ))) one for COUNT, one for DISTINCT, one for COLLECT. Let me know if updating the COUNTIFS to COUNT and removing one ) from the end works for you.

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!