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 Community Champion

07/06/22

You would need a SUMIFS.

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

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
0 · Share on Facebook Share on Twitter

Categories

Trending Posts

If you use Smartsheet EU, is the Outlook Integration (NAA) working for you?
If you use Smartsheet EU, is the Outlook Integration (NAA) working for you?
IF Formula
Hi - Below is my current formula that i am receiving an #INCORRECT ARGUMENT SET error on, and here is what i'm trying to obtain: If Scope Request is checked AND Scope Approved is checked, then "Committed" , if Scope Request is checked and Scope Approved is unchecked, "Identified" , if neither Scope Request nor Scope…
How do I ensure the PDF doesn't save to attachments using the Docusign Integration
Hi all, Hoping someone can help. Using the docusign integration and it works great, only issue I'm having is that the PDF of the completed contract is saving to the attachments automatically. Is there a way or turning off this feature so that the attachments stay clear?

woman with hands out and open

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