I am trying to count individual items within a multi-select cell so that I can reflect the data in a chart in a Dashboard. For example: If I want to find out how many people chose "Travel --- Reimbursement" in a multi-select field, how do I count just the "Travel --- Reimbursement" if various cells have other items in it (i.e. Travel --- Reimbursement, P-Card Payment, and Admin Tasks). Any suggestions would be greatly appreciated! Thanks! Karen

Try something like this... =COUNTIFS([Multi-Select Column]:[Multi-Select Column], CONTAINS("Travel --- Reimbursement", @cell))

What formula do I use to count individual items in a multi-select dropdown cell?

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Divide by Zero Error With AVG(COLLECT(...
Hoping someone can help because I am totally twisted with this one. I don't use AVG(COLLECT very often so I may be missing something simple here… What I'm trying to do is take the average of Column17 where both the year (Column22) and the weekday (Column9) match the year and weekday that I've indicated in Column21. (Yes I…
Formula to Check Restricted items in a Multi List Drop Down
I have a field "Failure Summary" in a sheet that has a drop down list that allows multiple selections. I want to write a formula that will check mark those specific items in the drop down list, if a corresponding column@row has "NO" as the value in that field. Is it possible to write a formula to do this?
How to automatically update text every week?
Hello, So I have two columns: "Date Week Ending" that lists the last Saturday of each week and "Reference" that lists an X value. I want to have the X value appear for the PREVIOUS week ending date when my current week starts. For example, if today is 9/9 then I want the "X" value to appear for the week ending date of 9/7.…