Formula Needed
I need to write a formula that will allow me to parse out a specific number or % (in this case 100%) in a column group of %s and then divide the sum of all those 100%s by the total number of %s such that I get a % of the total number of 100% for that group. IOW, say there are two 100% in my column of 5 total %s...the other three being 45%, 32%, and 3%. I need to show in the cell I place this formula into that there are 2 cells with 100% and then divide that 2 by the total number of cells with %s in them (5 in this case) such that the resultant is 20%. Does that make sense? I'm new to writing formulas in SmartSheet.
Best Answer

=SUMIF([Primary Column]2:[Primary Column]7, 1) / COUNTIF([Primary Column]2:[Primary Column]7, [Primary Column]@row)
The problem with smartsheet is that it takes % values as pure numbers. So once you get the value from the formula, you can convert to %.
Hope it helps!!
Answers

=SUMIF([Primary Column]2:[Primary Column]7, 1) / COUNTIF([Primary Column]2:[Primary Column]7, [Primary Column]@row)
The problem with smartsheet is that it takes % values as pure numbers. So once you get the value from the formula, you can convert to %.
Hope it helps!!

Could you explain what the final entry "...@row" means?

NM. I figured it out. Thanks. It worked!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!