# How do you count Columns in Smartsheet's

Options
✭✭✭

Column1 + Colum2 + Colum3

I need a formula that could add totals from 3 columns = Example= Risks + Issues+

Assumptions = Total

See screenshot

• ✭✭✭✭✭✭
Options

=VALUE(Risks@row) + VALUE(Issues@row) + VALUE(Assumptions@row)

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• ✭✭✭
edited 01/26/22
Options

Thank you, Jeff! When I enter that formula I get #UNPARCEABLE

Attached is the screenshot of the values

• ✭✭✭✭✭✭
Options

I hope you're well and safe!

Try something like this.

```=SUMIF([Count of Risks]@row:[Count of Dependencies]@row, <>0)
```

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

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

• ✭✭✭✭✭✭
Options

That formula works when adding up number values or numbers stored as text. Even with values of 0 it works.

Looks like you are calculating or linking in your values from somewhere else. What are the underlying formulas like?

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• ✭✭✭
edited 01/26/22
Options

Yes, that is correct! We have these values linked from an Intake form...

However, I am excited to say Andree' formula worked

=SUMIF([Count of Risks]@row:[Count of Dependencies]@row, <>0)

Thank you both for your help :-)

• ✭✭✭✭✭✭
Options

Excellent!

Happy to help!

Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up 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!