SUM(COLLECT/SUMIFS( based on multi-select


Hi everyone,

Does anyone have a formula already handy that does this? Looking to SUMIFS values where the variable is one of the options in the dropdown value?

This is a cross sheet formula pulling from a table where there is only one country per cell, but looking to aggregate (show me everything in this region).


Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Switch the pieces inside of the HAS function around like I have in my example.

    Generally speaking, the has function is more designed to work with finding a single text string in a range of multi-select cells. In this case you are working backwards. You are wanting to find the options within a single multi-select cell in a series of text string cells. Flipping the search value and range around backwards should give you backwards functionality.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!