SUMIF using CONTAINS from a different sheet

Hello!

I am trying to sum from a certain column when another column contains the word "RSMAS", this is what I am trying and it doesn't seem to work:

=SUMIF({Completed Request - Safe Return to Campus Range 2}, CONTAINS("RSMAS", {Completed Request - Safe Return to Campus Range 3}))

Any ideas?

Thank you!!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!