Need help with cross reference sheet using SUMIF
I am trying to cross ref a sheet that has hours entered by contact list and sum the total hours kept in a seperate sheet
Here is the formula i am using but getting zero in stead of 15 =SUMIF({Tot hrs}, [Assigned To:]@row, {Assigned to})
Any help will be appreciated
Best Answer
-
Hi @Bday, I think you need to switch position of {Tot hrs} and {Assigned to}.
Try this:
=SUMIF({Assigned to}, [Assigned To]@row, {Tot hrs})Best!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)
SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: — Auto Sorting — Sorting with Filters — Report PDF Generation — Copy and Paste Conditional Formats — Copy and Paste Automation Workflows — Column Manager — and so many more.
Answers
-
Hi @Bday, I think you need to switch position of {Tot hrs} and {Assigned to}.
Try this:
=SUMIF({Assigned to}, [Assigned To]@row, {Tot hrs})Best!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)
SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: — Auto Sorting — Sorting with Filters — Report PDF Generation — Copy and Paste Conditional Formats — Copy and Paste Automation Workflows — Column Manager — and so many more.
-
That did it thank you
-
You're welcome!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)
SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: — Auto Sorting — Sorting with Filters — Report PDF Generation — Copy and Paste Conditional Formats — Copy and Paste Automation Workflows — Column Manager — and so many more.
Help Article Resources
Categories
Check out the Formula Handbook template!