Question on how to create a percentage complete formula based on a status drop down menu

Andress76

I need help creating a percentage complete formula for a Due Diligence Checklist that I am working on. The status drop down menu completion option is "satisfactory". Can anyone help? If you need more information, please let me know.

Paul Newcome

Are you able to provide screenshots for reference or describe the structure of the sheet in more detail? Is it something where you have a parent row that will house the % Complete based on a count of "satisfactory" divided by the total count of child rows?

Andress76

We have not entered the data as of yet. Here is a screenshot. I have never had any formal smartsheet training, just trying to teach myself. Any guidance you are able to provide would be greatly appreciated.

Paul Newcome

Ok. And how exactly are you expecting this to work? Where would your formula go, and how would we decide which rows to evaluate in each formula?

Andress76

I am assuming the % complete column. I was hoping that for each section I could divide the amount of satisfactory responses in the status column by the total number of rows in each section.

Paul Newcome

I figured the % Complete column. Haha. I meant which row(s) the formula was to go on. If you want it on each of the black rows and it is to evaluate each of the rows beneath it until it gets to the next black row, then I would suggest first indenting each of the rows underneath of its respective parent/section header.

From there you would count how many of the child rows are "satisfactory" and divide that by the total number of rows in the section.

=COUNTIFS(CHILDREN(Status@row), @cell = "Satisfactory") / COUNT(CHILDREN(Question@row))

Andress76

Thank you! I will try this once my morning meetings are over.

Paul Newcome

Happy to help. 👍️