I'm trying to create a formula that will calculate when there are more than 1 item checked in a column to display accurately in my dashboard count.
Example:
My Strategic Initiative column has the ability to choose multiple SI's for 1 Project. The project has 2 or more SI's, my current formula is not calculating these to the dashboard. Here is my current formula:=COUNTIFS({MI2 Strategic Initiatives}, "1a - Integration of data elements for care coordination, quality management and financial performance")