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
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.
Comments
-
Hi Dana,
You might try using the NOT function in your COUNTIF formula. You may need to use a COUNTIFS formula if you need the formula to meet multiple conditions.
Details on this are available in our Help Center: https://help.smartsheet.com/articles/775363-using-formulas
-
Thanks for the help Shaine, I'll see if I can figure it out using the information you provided.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives