-
How to find the largest Items in a list and their corresponding Item names?
Hi, I'm trying to identify the TOP 5 most Requested Items in my Inventory list. I have a formula in place that finds the value of the Top 5 (Formula #1); however, my formula (Formula #2) that finds the corresponding Item Names of the TOP 5 has some limitations. Here's the breakdown: CURRENT FORMULA Formula #1 returns the…
-
COUNTIFS referencing date ranges specified in Sheet Summary
I'm trying to count the number of cells (dates) that fall between two dates that are selected in sheet summary. In excel I've been able to make this work =COUNTIFS($C$7:$C$47,">="&$H$1,C7:C47,"<="&$H$2) H1 and H2 being the relative date range I'm wanting to count between. I just don't know how to convert this into…
-
How to add percentage with a blank cell and get the result in percentage format?
Hello everyone, I am adding 2 different Efficiencies to show the Total efficiency. When there are values in the cell it works just fine, but when I am adding a percentage with a blank cell (or even a Zero) , the final result doesn't get converted to the Percentage format. Any idea how I can make the values in percentage…
-
Sheet Summary formula for counting unique values within a multi-select dropdown column?
I am trying to count the number of unique systems used within a workflow. I have dozens of possible internal systems listed within a restricted, multi-select, dropdown menu. As these systems are populated to the grid (sometimes multiple within a single field), does anyone have a formula that can generate the result below?…
-
Status Formula
Hi all, I am struggling to create a formula that works and wonder if you can help me…. Duration Equal to or Less than 0, Gray. Duration Greater than 0 but “Email Sent” & “Return Old Device” unchecked, Yellow. Duration Greater than 20 but “Email Sent & “Return Old Device” unchecked, Red. Duration Greater than 0 and “Email…
-
Would Like to Copy a value from one location to another weekly
Hello! I have 2 sheets SHEETA and SHEETB. SHEETA has a ton of data in it and I want to take a value from one cell inside or the sheet summary it and copy it weekly to another sheet. I know I can copy rows but that is not an option for me. Is there another method I could utilize to automate this?
-
ISBLANK = stumped
Hi all, I am using "Weeknumber" to return the week number for the yellow column where there is an entry, but I would like the green cells to remain blank if the yellow cells have no value. Please help me with the formula. Thanks in advance!
-
Information from multiple columns into one
I have a sheet that includes department and sub-department data, which is collected from a form. The sub departments all populate into different columns, so i have sub department columns (A, B, C, and D). For each row, there is only information in ONE of those columns because people only have one subdept. I want to create…
-
Formula not working
Hi The following formula in my summary sheet is giving 6 as the result, which is incorrect. The correct number is 87. =COUNTIF({Record ready}, <>"Yes") When I create a filter in the source sheet, it is giving the correct result that is 87 records. Any clues please?
-
Row number
Hi Thrill Seekers, I am seeking a way to access the row number of a row in a sheet. I would be very happy if this came in the form of a SmartSheet function (let's call it Row) so that I could create formulas like "=Row()" for the current row number or "=Row()+2" for the number of the row two rows below the current row.…
