How to count Status using Multi-select Drop-down list as input values
I'm new to Smartsheet and I need your help with formulas/functions.
I have a mapping sheet with below two columns. Currently I have 30+ scenarios and this list may increase in future.
In my master sheet, I have multi-select dropdown column [Scenario Name]. I need to reference mapping sheet and show [Status: Delivered] and [Status: WIP] count for each cell based on the scenario's selected from the drop-down list.
Please can someone help me resolve above challenge.
Appreciate your help!
Help Article Resources
Check out the Formula Handbook template!