Count PM name + % completed based on 20%, 50% and 90%
Answers

@darlington.fernandes can you explain further what you are trying to do? It seems like you are trying to get 3 different data points into one cell.
are you trying to count number of projects greater than 20%, then number of projects greater than 50%, and then number of projects greater than 90%?
if you want all that in one cell you need something like
=">20%" + COUNTIFS(PM:PM, "Cameron Kang", [% Complete]:[% Complete],>0.2) + " >50%: "+ COUNTIFS(PM:PM, "Cameron Kang", [% Complete]:[% Complete], >0.5)
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 61 Global Discussions
 46 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!