Need to Count Projects by Assignee AND Status

I am having difficulty getting a project count by Person AND has to be one of 3 Statuses. Currently I have this formula to look at project count by a certain person but its pulling in all projects even DONE or Archived. NOTE: The assignee can be more than one person

=COUNTIF(GDC:GDC, FIND("first last", @cell) > 0)

All I want to do is add in another parameter to look at LIVE projects; so projects with a status of "In Progress" or "Meeting Required" OR "On Deck". I simply cannot figure it out.


Best Answer

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    edited 02/02/22 Answer ✓


    Switching your formula to COUNTIFS allows you to specify multiple criteria ranges, and the OR function lets you specify more than one possible criteria for a range. Try this:

    =COUNTIFS(GDC:GDC, FIND("first last", @cell) > 0, Status:Status, OR(@cell = "In Progress", @cell = "Meeting Required", @cell = "On Deck"))

    where Status is the name of your status column.


    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!