Hello,
I am looking for the formula to sum a column (Work Stream) with specific text. The column is multiple select drop down. The drop down options are Available, Unavailable, Assigned and R&R. I need to sum all the rows that contain the drop down option "Available", even if they may contain other drop down options.
I have tried the below formula, and several others with no luck
=SUMIF([Work Stream]:[Work Stream], "Assigned")
Thank you!