Seeking Formula output in ratio when conditions are met in other columns with dropdown selections

Options
Ari_Ari
Ari_Ari ✭✭✭
edited 12/20/23 in Formulas and Functions

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!