SUMIF Question
Hi all,
I have a sheet where I log times later for employees. So there are different rows, each row has a date and then I enter LATE, or AWOL, or SICK in another cell.
Thing is there are different employees.
How can I SUM "Lates" for each employee?
I tried this, but it doesn't work
Answers
-
I hope you're well and safe!
Have you explored using a Report?
Would that work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Not familiar with Smartsheet reports. :(
-
I don't think we have Reports in our package
-
Hav a look here.
You could build a report and use the grouping/sum/count feature to get the necessary totals.
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Reports are included in all plans but are limited in the PRO plan.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks, I'll keep fiddling with the Formula. Easier than asking my boss for Money :)
-
Not sure what plan we have
-
You should be able to create a report regardless of what plan you have.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks
-
Happy to help!
Also, feel free to return to the post if it doesn't work out, and you'd like to use the formula options instead.
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I have this working for SUMIF until I added the Left Early line then it broke. It looks identical to me?
=SUMIF(Name:Name, "Scott Walstra (TY)", [Monthly Totals Late]:[Monthly Totals Late]) + SUMIF(Name:Name, "Scott Walstra (TY)", [Monthly Totals Sick]:[Monthly Totals Sick]) +
SUMIF(Name:Name, "Scott Walstra (TY)", [Monthly Totals Left Early]:[Monthly Totals Left Early]) +
SUMIF(Name:Name, "Scott Walstra (TY)", [Monthly Totals AWOL]:[Monthly Totals AWOL])
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 283 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!