Sum If Multi Drop Down Contains @Cell

Options

I am struggling to get a formula to work correctly. I have a "Crew" Column which is a multi select contact column. I want the crew to be able to select multiple members and enter a single "Hours" for the day. For example Antonio and Tacho work the same job for 10 hours. Then to have each persons total hours for the project populate in the total hours section. I can get it to work just fine with a single person. As soon as I select multiple it breaks.


It should be showing 20 hours each for person under column 11 under Total Hours


This works with only one selection in dropdown =SUMIF(Crew:Crew, ProductionCrew@row, Hours:Hours)

This doesn't work at all =SUMIF(Crew:Crew, CONTAINS(ProductionCrew@row, Crew:Crew), Hours:Hours)


Any help appreciated


Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!