SUMIF Partial Text


I'm trying to sum the contract amount if the contract status contains Awarded. Contract Status is a multi-select column so may contain more than one status.

=SUMIF({Contract Status}, CONTAINS(@cell, "Awarded", {Contract Amount}))

This is coming back as $0 when it should be over $57k.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!