-
Rank Vendors Based on Total Spend
Hello Community, I'm looking for formula that will rank the 'Offsetting Acct Names" by 'Supplier Total Spend'. As you can see below, I captured the total spend per supplier but need to rank these and report on the Top 10. Any assistance would be greatly appreciated!
-
Tally Duplicates Under First Occurrence
I have a count of incidents for each location. The "rank helper" column use to total the number of incidents beside the first occurrence of a name. For example: Bellflower has "2" incidents. I want the first listing for Bellflower to show the "2" in the "rank helper" column and additional Bellflower occurrences not display…
-
RANKEQ with multiple filtering criteria
I have been trying to rank my rows that are listed as "Tier 1" in the {Level} column in order of importance based on the following criteria: 1) Highest Rank: Rows with the oldest {R/O Create Date} AND BOTH {OOS} and {Warranty} columns are checked. 2) Second: Again, oldest R/O create date, with the {Warranty} column…
-
Rank Pivot Results WITHOUT DUPLICATES
Hey friends, I am trying to create a column that ranks (without duplicates) the results of a PIVOT configuration. The PIVOT config produces the SUM of rental dollars spent, in column "Grand Total-SUM 💲 Total Rental $ Amount {H}" respective to each listed equipment type, in column "⚠️Cat-Class Description". I'd like to rank…
-
Formula to Display Top 10 Rows with Lowest Ranking
I have a sheet that captures the average rankings assigned to requests in order of priority. I need a formula to create a metric that displays the Top 10 request IDs that have the lowest average ranking (lowest ranking = highest priority). Here is an example of what I need: The metric needs to be dynamic as the top 10…
-
How to create an automated update request for assigned tasks based on job roll
Sorry if this question has already been answered but I am having a hard time clarifying what I am looking for to search. I have a sheet of employees with a helper column (called structure) that is displays their job title as a number using descendants (lower the number the higher their position). If needed this can be…
-
Formula Help - Rank to be able to use on reports
Hi All, Just wondering if anyone can help me with your wisdom! From the list of assets below, I need to have top 5 or top 10 of most ordered as well as less ordered (please note there is a repetition of the same asset name throughout the sheet) and there's 2 x different categories: social and TV which need to be ranked in…
-
Ranking Prices by Name - Need Formula Help
Hi, So I can't seem to figure this out. Below I have the name of a manufacturer with how much we are spending with them in no particular order. I'd like to use a formula that tells me, in decending order, the top 10 manufacturers we've spent the most money on. I would need the information to be listed like below STERIS…
-
Trying to find the top three categories for Dashboard Metric
Hello, I have a list in my primary column with categories ([Primary Column]52:[Primary Column]93). The column to the right COUNT column has counts for the categories ([count]52:[count]93). I also have a ranking column next to that with the following formula in it from row 52-93 —> =RANKEQ([Count]@row, Count52:Count93, 0).…
-
Do you share your Smartsheet Community Accomplishments? If so, how?
Hello everyone! I'm curious how fellow community members share your accomplishments, if you do at all! The certification is an obvious one, but do you share your community rank? What about certain badges like Automagician, or being a member of a program like the Mobilizers? I currently have my certification highlighted on…
