Trying to say "and this column isnt blank"

Options

=COUNTIFS({Campaigns Status Count Range}, HAS(@cell, [Primary Column]@row), {Campaigns Range 1}, "Not Started", NOT(ISBLANK({Group})))

:( wont work

Best Answer

  • Julie Fortney
    Julie Fortney Overachievers
    Answer ✓
    Options

    HI @Billymacdo

    Try this:

    =COUNTIFS({Campaigns Status Count Range}, HAS(@cell, [Primary Column]@row), {Campaigns Range 1}, "Not Started", {Group},NOT(ISBLANK(@cell)))

    COUNTIFS formulas look for the range, then the criterion to evaluate that range for. (Range 1, Criterion 1, Range 2, Criterion 2, Range 3, Criterion 3…)

Answers

  • Julie Fortney
    Julie Fortney Overachievers
    Answer ✓
    Options

    HI @Billymacdo

    Try this:

    =COUNTIFS({Campaigns Status Count Range}, HAS(@cell, [Primary Column]@row), {Campaigns Range 1}, "Not Started", {Group},NOT(ISBLANK(@cell)))

    COUNTIFS formulas look for the range, then the criterion to evaluate that range for. (Range 1, Criterion 1, Range 2, Criterion 2, Range 3, Criterion 3…)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!