Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Counting Based on Two Items

Dan Lofdahl
edited 12/09/19 in Archived 2017 Posts

I am making a sheet to track the number of proposals we send out and how many turn into projects.

I want to be able to count them by which Project Manager did it. So I have a PM field for the Project Managers initials. I was using fields for each PM's Proposals. The formula I used was COUNTIF(PM:PM, "RM") for example and it seems to work OK.

The part I am having problems with is getting the number of ones for each PM that turn into projects.

What I am looking for is a count of the projects that a particular PM was successful getting.

I have a field for Project Number which only has a value if the proposal turned into a project.

How do I count the number of projects attributed to each PM?

Is there a cleaner way to do this?




This discussion has been closed.