Count occurrences of each variable of a multi-dropdown list


Hi, I'm building a lease administration tool to help negotiate some leases. Each row (lease) has several stages (preliminary, negotiating, at lease, executed lease, open). I want to create a dashboard metric to show how many rows are at a particular stage:

Preliminary - 5; Negotiating - 3; At Lease - 7, etc...

What would I do to count the occurrences of each variable in the drop down list so I can use them in the metric widget?

Thanks in advance!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!