SUM?COUNTIF?SUMIF?

Options

Eric Laitenberger

Eric Laitenberger ✭✭✭✭✭

07/06/22 in Add Ons and Integrations

Hello,

I would like add up number in the column if a other column =1 could you give me the formula please

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

07/06/22
Options
You would need a SUMIFS.

https://help.smartsheet.com/function/sumifs

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Categories

Trending Posts

Multi-tier reporting in Control Center?
I am looking for a way to set up a report in my parent blueprint so that: Every time a new child project is provisioned, a specific sheet from that project is added to the report at the parent level. The parent report is a collection of that sheet in all child projects. Things I tried that didn't work: -Adding the child…
Data Shuttle not updating blank values from source file?
Anyone else having this issue? All the Data Shuttles that I set up, are not anymore been bringing data to Smartsheet from cells that have changed to being blank in my Source Location. This was discovered yesterday, 10/17, when I received many reports from colleagues that work on different sheets that the data shuttle…
Embed Calendar App into SharePoint?
Can a Calendar App calendar be embedded into SharePoint? If so, are users still able to apply filters and change the view? Thanks!

Help shape the future of Smartsheet.
Share your ideas and feature requests.