SUMIF Question

MOCVDEngineer

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

Andrée Starå

Hi @MOCVDEngineer

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!

MOCVDEngineer

Not familiar with Smartsheet reports. :(

MOCVDEngineer

I don't think we have Reports in our package

Andrée Starå

@MOCVDEngineer

Hav a look here.

You could build a report and use the grouping/sum/count feature to get the necessary totals.

https://help.smartsheet.com/learning-track/smartsheet-intermediate/reports

✅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!

Andrée Starå

@MOCVDEngineer

Reports are included in all plans but are limited in the PRO plan.

MOCVDEngineer

Thanks, I'll keep fiddling with the Formula. Easier than asking my boss for Money :)

MOCVDEngineer

Not sure what plan we have

Andrée Starå

@MOCVDEngineer

You should be able to create a report regardless of what plan you have.

MOCVDEngineer

Thanks

Andrée Starå

@MOCVDEngineer

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!

MOCVDEngineer

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])