Issue with countif and find formula
Hello, I am trying to have number of projects owned by Project manager
I have used this formula :
=COUNTIFS({Digital Project Portfolio Plage 1}; FIND("xxxxx.xxxxx@xxxxxx.com"; @cell) > 0; {Digital Project Portfolio Plage 2}; "In Progress")
which is working well
But i am trying to use it with an email adress like xxx.xxxx.xxxx@xxxx.com, it is giving me a 0 value.
Any idea to avoid this issue with 3 args before the @?
Strange :-) and thx
Best Answer
-
It's working for me if I just set it up this way - the Find wasn't needed. But, is there more than 1 email address in your email address column (that's when you'd need Find)
=COUNTIFS([Email Address]1:[Email Address]12, "Mel.Cor.Bin@email.com", Status1:Status12, "In Progress")
Answers
-
It's working for me if I just set it up this way - the Find wasn't needed. But, is there more than 1 email address in your email address column (that's when you'd need Find)
=COUNTIFS([Email Address]1:[Email Address]12, "Mel.Cor.Bin@email.com", Status1:Status12, "In Progress")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!