Nesting SUMIFS in IF
Hello, is it possible to nest a SUMIFS within an IF statement to say If the value of this sumifs is greater zero display the sumifs, but display nothing if the value is not greater than 0?
Best Answer
-
Hahaha nevermind. The answer is yes, and I just had to put the first sumifs within the if statement within parentheses before the greater than zero part
Answers
-
Hahaha nevermind. The answer is yes, and I just had to put the first sumifs within the if statement within parentheses before the greater than zero part
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 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!
