Question on how to create a percentage complete formula based on a status drop down menu
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.
Answers

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?

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.

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?

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.

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))

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

Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!