Format SUM function in a report
Answers
-
No problem at all! π
-
Hi Again Genevieve P.Β ...
Additional request is to exclude another name from the total.
To exclude one the following worked well:
=SUMIFS([Payment status]:[Payment status], Institution:Institution, <> "Stanford")
How will the formula look to exclude another "name" (Stanford & ICO)
Thanks!
-
Hi @TaliRXM
Take a look at the second formula in this post! You should be able to exclude multiple values by using AND(@cell <> "Value", @cell <> "Value)
-
Thanks Genevieve to you and Arvin from Smartsheet 1:1 support for your help and support!
-
Wonderful! Glad we could help.
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives