Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
If Blank Formula
Can someone help 'I am trying to add up a Value Column (2021 Opportunity Log Range 1) with the criteria
if the (Estimator) column is NOT blank and the (RANK) column has a "A" in it.
My formula above I get the below
Answers
-
@Shannon Lacerda I think you need to use SUMIFS not SUMIF ...
Dale
-
@Dale Murphy unfortunately I tried that as well, I get #INVALID OPERATION when I use SUMIFS
-
@Shannon Lacerda Can I see the SUMIFS formula you tried? The structure is a bit different ...
Dale
-
@Dale Murphy thanks I moved the formula around and it works thanks
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.6K Get Help
- 472 Global Discussions
- 200 Use Cases
- 513 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 520 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I am struggling to get this formula to work. Any thoughts? =IF(([FY26 Membership Level]@row = "Basic", "$2,000", IF[FY26 Membership Level]@row="Enhanced Level 1", "$8,000", IF[FY26 Membership Level]@r…
- I keep getting an "invalid operation" error message with this formula. Can someone spot where I went wrong? I am not great at formulas. The goal is for multiple criteria (IF statements) to match befor…
- Here is my first IF statement that when the Site Survey task gets populated it puts it into the complete status. =IF(ISBLANK([Order Sign Date]@row), "", IF(ISBLANK([Site Survey Complete Date]@row), "P…