# Adding to Formula: 1 out 10

Options
✭✭✭✭✭✭

Good afternoon Smartsheet Community:

I am trying to add to this formula:

=("Priorities for 9/23 Week: " + COUNT(CHILDREN()))

I want it to Count the number of Done: Priorities for 9/23 Week 1 out Of 10.

Thanks

• ✭✭✭
Options

Hi -

Do you have an example of the sheet that you are using? It will help answer the question - thanks!

Sean

• ✭✭✭✭✭✭
Options
• ✭✭✭✭✭✭
Options

Hi @Ray B,

I’ve requested access so that I can see if I can help!

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭
Options

Access Granted! I had this formula worked out with another employer but did not copy it properly to use on other projects

• ✭✭✭✭✭✭
Options

@Ray B Is it the PCI one, Tony? 🤔Where in the sheet is the formula?

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭
Options

I just added it

• ✭✭✭✭✭✭
Options

I am close! The only problem I have is that instead of 4 out 4, I am receiving 4 out of 40 as a result. Formula Below:

=("Jenkins Automation: " + COUNTIF(CHILDREN([% Complete (Actual)]2), 1) + " of " + ((COUNTIF(CHILDREN([% Complete (Actual)]2), 1) + (COUNTIF(CHILDREN([% Complete (Actual)]2), 0) + "Task Have Been Completed"))))

• ✭✭✭✭✭✭
Options

It is also not checking for 100%. It is just looking at anything with 1 (i.e. 10%)

• ✭✭✭✭✭✭
Options

How did it go? Did you manage to get something set up?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭
Options

No, not yet

• ✭✭✭✭✭✭
Options

@Ray B Ok. Can you share the new version and I'd be happy to take a look again?

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭
Options

New Sheet Shared

• ✭✭✭✭✭✭
Options

Thanks!

I'll have a look and get back to you!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!