Seeking Formula output in ratio when conditions are met in other columns with dropdown selections
Hello,
Here is another formula attempt for below table:
I want to check if the % Complete is "Complete" and Standard is "I - Availability of Services" for the current row, is true, then I need the ratio of rows that meet both conditions to the total number of rows in the Standard column.
Here is my attempt at the formula:
=IF(AND([% Complete]@row = "Complete", (Standard:Standard)@row = "I - Availability of Services"), COUNTIFS([% Complete]:[% Complete], "Complete", (Standard:Standard), "I - Availability of Services") / COUNT(Standard:Standard), 0)
I am getting Unparseable error. What am I missing?
Appreciate the help.
Answers
-
Your syntax is off.
=IF(AND([% Complete]@row = "Complete", Standard@row = "I - Availability of Services"), COUNTIFS([% Complete]:[% Complete], "Complete", Standard:Standard, "I - Availability of Services") / COUNT(Standard:Standard), 0)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thank you @Paul Newcome ! This works!
Any ideas on how best to check on the syntax? When I look at the formula example SmartSheet gives you, it is not so straight forward.
Thanks,
Ari
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!