Counting Employees in Assigned To Column

Options

Hello,

I can count how many times somebody's name is in the Assigned To Column, but when I have multiple people assigned to one project, my formula does not count either person. Does anybody know what I am missing?

Formula is =COUNTIFS({Assigned To}, [Primary Column]@row, {Status}, "Backlog")

Thank you,

Derek


Answers

  • Yuan Wong
    Yuan Wong ✭✭✭
    Options

    Hi @Derek Snow ,

    your current: Formula is =COUNTIFS({Assigned To}, [Primary Column]@row, {Status}, "Backlog")

    try using: CONTAINS(criteria, @cell)

    also take out the [ ]

    so correct format Formula is

    =COUNTIFS({Assigned To}, CONTAINS(Primary Column@row,@cell), {Status}, "Backlog")

    OR

    =COUNTIFS({Assigned To}, CONTAINS(Primary Column1,@cell), {Status}, "Backlog")

  • Yuan Wong
    Yuan Wong ✭✭✭
    Options

    sorry correction**...you have a SPACE between Primary -and- Column. so you do need the [ ]

    try Formula

    =COUNTIFS({Assigned To}, CONTAINS([Primary Column]@row,@cell), {Status}, "Backlog")

    OR

    =COUNTIFS({Assigned To}, CONTAINS([Primary Column]1,@cell), {Status}, "Backlog")

  • Derek Snow
    Options

    It turns out this is the correct formula. It needs to use HAS instead of CONTAINS when counting contacts.

    =COUNTIFS({Status}, "Backlog", {Assigned To}, HAS(@cell, [Primary Column]@row))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!