Assistance with Creating a Formula for Top 10
Hello Smartsheet experts! I have a question that I am hoping you can assist with.
I am attempting to build the back-end for a Dashboard widget that displays the top 10 occurrences of a text name that is pulled from the "Name" column in three different sheets (sheet A, sheet B, and sheet C). All three sheets contain the same field names. Additionally, I would also like to be able to include only those values that meet a specific criteria called "Non-Compliant" specified in another drop down box field (single select).
So initially, I would like to know how to create a formula to pull specific text from three different sheets, count those text instances up, and then be able to sort from highest to lowest (so that I can add a chart via Dashboard reporting).
Ive done a bit of reading through the community forums but I think I am confusing myself more than helping. If someone would be kind enough to point me in the right general direction, I would be very grateful.
Help Article Resources
Check out the Formula Handbook template!