Tonna Heyneke
Tonna Heyneke ✭✭✭
edited 12/09/19 in Formulas and Functions


I'd like a formula to calculate the below

SUM the leave days Request(Column Number of Days) against the employee(Name Column) if Approved(Manager Column) and Approved(EXCO Column). If either one of them are not approved then don't SUM the leave days.

This is what i have so far but cant seem to get it to work.

=SUMIF([Name and Surname]1:[Name and Surname]8; [Name and Surname]15;and([Manager Approval]1:[Manager Approval]8 = "Approved"; and([EXCO Approval]1:[EXCO Approval]8 ="Approved"; [Number of Days]1:[Number of Days]8).

Ps, I'm setup to use ";" instead of "," separator.

Kind Regards



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!