End date is in the past

Options

this runs
=COUNTIFS({Group}, HAS(@cell, [Primary Column]@row), {Campaigns Range 1}, <>"Complete", {Campaigns Range 1}, <>"deferred")

this doesn't
=COUNTIFS({Group}, HAS(@cell, [Primary Column]@row), {Campaigns Range 1}, <>"Complete", {Campaigns Range 1}, <>"deferred", {End Date} < TODAY())

{End Date} is just a column with a date

Answers

  • Mark.poole
    Mark.poole ✭✭✭✭✭✭
    Options

    @Billymacdo

    You forgot the comma for the end date part.

    =COUNTIFS({Group}, HAS(@cell, [Primary Column]@row), {Campaigns Range 1}, <>"Complete", {Campaigns Range 1}, <>"deferred", {End Date}, < TODAY())

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!