Hi, I currently have a formula that is counting the total number of rows in another sheet that have a "Status" = "In Progress" and have a "Value Stream = "Platform & Shared Services". See attached screenshot - left side of screenshot.
This formula worked just fine when in the other sheet, the "Value Stream" column was a single select dropdown field. Now this field is a multi-select dropdown and the formula is only counting the number of instances where the "Value Stream" value is explicitly the single value. In the screenshot you can see on the right side, a total of 6 projects that contain a "Value Stream = Platform & Shared Services", but only 3 of them explicitly have "Platform & Shared Services".
The formula is current returning a count of 3 projects but how do I update this formula to look for values in the "Value Stream" column that contain "Platform & Shared Services"?
Note: I have tried adding in "CONTAINS()" into the formula but I am not doing it right.
Thank you in advance!
