Sumifs +HAS
I am getting error message everytime I try to do a sumifs with has
I am trying to sum the January column, if the PM is Cameron, the committed/spec column is committed. I will need the formula to drag over to summing february, march, april, etc.
What am I doing wrong?! Thank you for any help!!
Answers
-
Since you're using this formula inside the column that you're trying to sum, on a row that matches the first criteria in the formula, you can try changing the order of your criteria so that the row you're on is immediately excluded from consideration. Smartsheet formulas work left to right, and when considering criteria, they shrink the potential collection as it moves from one criteria to the next.
So if your first criteria is where Committed/SPEC equals 'Committed', immediately the row the formula is on is removed from consideration.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Thanks, Jeff!
I tried this but now I am getting the unparseable error
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!