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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!