Smartsheet Summary Counting Assigned to with multiple people in the field.

AmandaHore

I have the sheet below and I want to count for each person how may items are pending their approval. The formulas I have tried only find where it is only one person in the column. Where there are two people in the column it ignores the column. I have tried

=COUNTIFS([Pending Approval From]:[Pending Approval From], "emailaddress"). I want to do this in sheet summary so I can then show on a dashboard.

Any suggestions.

Paul Newcome

You need to use a HAS function.

=COUNTIFS([Pending Approval From]:[Pending Approval From], HAS(@cell, "emailaddress"))

Paul Newcome

You need to use a HAS function.

=COUNTIFS([Pending Approval From]:[Pending Approval From], HAS(@cell, "emailaddress"))

AmandaHore

That is excellent - thank you

Paul Newcome

Happy to help. 👍️