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.

COUNTIF Formula Help

Dana A
Dana A
edited 12/09/19 in Archived 2017 Posts

Set up a set of columns: lead, support and stage. I can get the COUNTIF formula to work for me to count the names of the people assigned in the lead and support columns, but I need help figuring out how to get it to also look at the stage column and NOT count that name if the cell in that column says CLOSED.


This is the COUNTIF formula I'm using now:

="NAME (" + COUNTIF([Lead]:[Support], "NAME") + ")"


It gives me a count of 7, but if I can get it to look at the Stage column and not count if it says CLOSED, I should get a count of 4. 


Any help would be appreciated.



This discussion has been closed.