-
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…
-
Rankeq and Collect formula
I am having trouble with a Collect formula when I add another criteria. The Collect formula is embedded in a Rankeq formula. This formula (Rank column) works: =IFERROR(RANKEQ(DateNum@row, COLLECT(DateNum:DateNum, DateNum:DateNum, @cell <> ""), 0), "") When I add to the Collect portion of the formula (RankKL column) I get a…
