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.
SUMIFS with sheet references.
Hello,
I've got this formula working like this.
=SUMIFS({DayCount}, {EmployeeName}, [Employee Name]@row, {ReasonforAbs}, "Vacation")
However when I change the criteria to "PPL / Sick" it's returning 0 when there are clearly cells to count.
=SUMIFS({DayCount}, {EmployeeName}, [Employee Name]@row, {ReasonforAbs}, "PPL / Sick")
I've tried the same with other criteria and it seems to be just this one.
Richard E. Lucas
Best Answers
-
I suspect it's the special character "/" in your criteria. Change your values and remove the slash, and change the formula to match, and see how it works then.
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!
-
Changed the / to - and it worked. Must not like the /.
Richard E. Lucas
Answers
-
I suspect it's the special character "/" in your criteria. Change your values and remove the slash, and change the formula to match, and see how it works then.
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!
-
You would also want to ensure that the data in the sheet matches your criteria to include the spaces on either side of the slash. Upper vs lower case doesn't matter, but everything else needs to match.
-
Changed the / to - and it worked. Must not like the /.
Richard E. Lucas
-
@Richard Lucas Glad it worked for you!
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!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!