Count occurrences of each variable of a multi-dropdown list
Douglas Jerum
✭✭✭✭
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!
Answers
-
You would create a list where each option is is listed and then use a COUNTIFS function to count how many of each.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!