Count of Children Incorrect
Smartsheet Community:
My Formula Is the Incorrect total number of Children. I am sure it is a Minor Tweak but I cannot seem to find where I need to correct my formula.
Current Formula:
="Site Execution: " + COUNTIF(CHILDREN([% Complete (Actual)]@row), 1) + " of " + ((COUNTIF(CHILDREN([% Complete (Actual)]@row), 1) + (COUNTIF(CHILDREN([% Complete (Actual)]@row), 0)) + " Completed "))
Results 21 Of 48 Completed
However the Total Number of Children is 52. Therefore, it should be 21 Of 48 Completed.
Thanks
Best Answer
-
My apologies. I missed that the two parenthesis at the end should have been removed from the original formula in addition to my other changes.
="Site Execution: " + COUNTIFS(CHILDREN([% Complete (Actual)]@row), 1) + " of " + COUNTIFS(CHILDREN([% Complete (Actual)]@row), OR(@cell = "", @cell <> "")) + " Completed "
Answers
-
Hope you are fine, please try the following formula :
="Site Execution: " + COUNTIF(CHILDREN([% Complete (Actual)]:[% Complete (Actual)]),@cell=1)) + " of " + COUNT(CHILDREN([% Complete (Actual)]:[% Complete (Actual)])) + " Completed "))
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Received an Error: Unparseable
-
Here is my suggestion:
="Site Execution: " + COUNTIFS(CHILDREN([% Complete (Actual)]@row), 1) + " of " + COUNTIFS(CHILDREN([% Complete (Actual)]@row), OR(@cell = "", @cell <> "")) + " Completed "))
-
@Paul Newcome Received an Error: Unparseable
-
Are you able to provide a screenshot of the formula in the sheet similar to the screenshot below?
-
What about the formula I previously provided?
="Site Execution: " + COUNTIFS(CHILDREN([% Complete (Actual)]@row), 1) + " of " + COUNTIFS(CHILDREN([% Complete (Actual)]@row), OR(@cell = "", @cell <> "")) + " Completed "))
-
When I copy and Paste it is Unparseable. Screen Shot Below
-
My apologies. I missed that the two parenthesis at the end should have been removed from the original formula in addition to my other changes.
="Site Execution: " + COUNTIFS(CHILDREN([% Complete (Actual)]@row), 1) + " of " + COUNTIFS(CHILDREN([% Complete (Actual)]@row), OR(@cell = "", @cell <> "")) + " Completed "
-
@Paul Newcome That Worked, Thanks!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!