-
Rank Formula Multiple Results
I have previously received help with Ranking formula where there is more than 1 result it needs to rank the most recent week, which was resolved and worked fine - until last week. The new issue is that I have the rank 3 & 4 is being excluded When reviewing the data I think this is the issue, just not sure how to adjust the…
-
Rankadv dates, or DATEVALUE
Hi, I was trying to rankadv a series of dates (to calculate employee seniority), which isn't yet a feature. Since I cannot do that, I wanted to turn that date into a number that I could then rank, which in Excel I can do with the DATEVALUE function. Is it possible to get either of those in SmartSheets?
-
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…
-
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…