# Combining Multiple Formulas

Options
✭✭✭✭

Hello,

Trying to help a co-worker out with combing these formulas into 1. She thinks adding AND is the solution but i was not sure. Here are the formulas broken out below that we need to make into 1 formula.

=COUNTIFS({IPT Consolidated Backlog Range 1}, @cell = "Sales Operations", {IPT Consolidated Backlog Range 2}, @cell = "Ready for Dev")

=COUNTIFS({IPT Consolidated Backlog Range 1}, @cell = "Sales Operations", {IPT Consolidated Backlog Range 2}, @cell = "Ready for Release")

=COUNTIFS({IPT Consolidated Backlog Range 1}, @cell = "Sales Operations", {IPT Consolidated Backlog Range 2}, @cell = "QA")

=COUNTIFS({IPT Consolidated Backlog Range 1}, @cell = "Sales Operations", {IPT Consolidated Backlog Range 2}, @cell = "UAT Validation")

• ✭✭✭✭
Options

Hi,

Just looking a bit more context but if you are just counting these figures out can you not just leave them as 4 separate formulas and then have a total cell adding these numbers together?

Why do they need to be in one?

• ✭✭✭✭✭
Options

Yea not sure what result you're looking for but could you just add those countifs together in one formula?

=COUNTIFS({IPT Consolidated Backlog Range 1}, @cell = "Sales Operations", {IPT Consolidated Backlog Range 2}, @cell = "Ready for Dev") + COUNTIFS({IPT Consolidated Backlog Range 1}, @cell = "Sales Operations", {IPT Consolidated Backlog Range 2}, @cell = "Ready for Release") +COUNTIFS({IPT Consolidated Backlog Range 1}, @cell = "Sales Operations", {IPT Consolidated Backlog Range 2}, @cell = "QA") + COUNTIFS({IPT Consolidated Backlog Range 1}, @cell = "Sales Operations", {IPT Consolidated Backlog Range 2}, @cell = "UAT Validation")

• ✭✭✭✭✭✭
Options

I hope you're well and safe!

Try something like this.

=COUNTIFS({IPT Consolidated Backlog Range 1}, @cell = "Sales Operations", {IPT Consolidated Backlog Range 2}, OR(@cell = "Ready for Dev", @cell = "Ready for Release",@cell = "QA",@cell = "UAT Validation")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

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

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

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!