-
How to retrieve multiple values from a column based on a primary key from a different column
I have data in Sheet 1 like mentioned below - I need to get values in a different sheet ( Sheet 2) like mentioned below - Basically I would like to display all the jira story IDs ( unique values) and list all the associated engagement IDs (multiple matching values). Please help me with a solution for this. Thanks
-
How to change count to percentage in stack bar chart?
Hi SS Community, I have attached two stacked bar charts I created for showing status of part shipments between sites. An example of the formula I used in my supporting sheet is: =COUNTIFS({X-Site Shipping Status}, "Delivered", {X-Site Build Stage}, "POM to IHA") If it is a formula issue, what do I need to add/change about…
-
Need help applying AvgIf and/or AvgCollect
I am trying to find the average of a column with specific criteria. I have avg TAT and I am trying to find the average when the Run Type is specific.
-
Counting Past Due Days
Hello! I'm hoping you can help me with a formula. I have 3 columns: Due Date, Over Due Days, and Paid Date. I want the "Over Due Days" to calculate how many working days are past due based on the "Due Date" and today's date while keeping the "paid date" cell blank. Once I enter the "Paid Date" I would like to keep the…
-
Creating a formula to track number of days but with a catch
So I have been tasked with creating a formula that tracks the number of days an element is "No". However, there are multiple forms submitted each day so I do not want to count the number of times a "No" is selected. It needs to be a formula that counts the consecutive days but then resets to 0 if the element has a "Yes"…
-
Flagging Duplicate Values
Searching through community I found a way to have flags for duplicate values - however, it seems that this formula is not working as I'd hope. =IF(COUNTIFS(SKU:SKU, SKU@row) > 1, 1) I don't get an error - it just doesn't check the box. As you can see, there IS a duplicate value in SKU.
-
I want to reference a cell but only if other cells are blank
Lets say I have 4 rows with the last row being the row with the formula. I want that formula to look at row 3, if it is blank, then reference row 2, and if row 2 is blank then reference row 1. So the formula returns the date in row 1, but only if row 2 and 3 are blank. If row 2 is not blank, then it returns the date in row…
-
Ugh....need help with a cross sheet index/match formula
I have a drop down column titled "SITE", when a SITE is selected, I need the Terminal ID# column to auto populate from another DATABASE sheet for which the SITE column is exactly the same type and title. =INDEX({SITE Database Range 1}, MATCH([Terminal ID]@row, {SITE Database Range 2}, 0)) Get an UNPARSEABLE error........
-
Pre-Populate Form with Entire Field from Sheet
Hello Community, I am trying to figure out how to pre-populate a form with a multi-word field. I know how to populate the form with a field and can provide part of my formula below, but it only brings in the first word of the field and not the entire thing. Can someone please let me know how to bring in the entire field?…
-
Formula for multiple columns - Incorrect Argument Set Error
I have spent more time than I'd like on this formula. I keep getting a #Incorrect argument set error. I would like to provide different direction based on when specific columns have a yes answer. It was working fine until I added the final column Used to Provide Information - Handout. Now I can't get the formula to work…
