SUMIF for Contact Column Properties


My formula comes back as #No Match but when I filter, I see the results I need. I am hoping you can assist!

I am trying to calculate the amount of time spent for a contact person. Here is the formula I have so far:

=SUMIF([Contract Phase Assigned to]:[Contract Phase Assigned to], "Stephanie Bauder", [Total Time Spent Contract Phase]:[Total Time Spent Contract Phase])

Can you help?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!