SUMIFS with Contact Cells

I have employees submitting their time sheets to an intake form. I have a summary sheet that calculates their total hours per time code. I am finding that some employees are submitting their emails, and some are submitting their contact card. This is an issue when trying to add up hours since it will only calculate either the email address, or the name. I would imagine there are several approach to this but I am struggling with what the easiest solution would be.

Summary Sheet Formula:

Summary Sheet:

Time sheet Intake Sheet (Email was Submitted)

Time sheet Intake Sheet (Contact Card / Name was Submitted)

Can I force employees to submit their form with the contact card / Name? Or can I add an OR function to my formal so it sums if it is an employee email OR their name.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!