-
Get a status by needing 5 dates filled out
Hi, So i need a status column after the last date column here that says complete when all the dates are filled in or pending when only 1,2,3, or 4 dates are put in.
-
Update Request Email Notification - Limit fields to edit
I'm creating an email notification from a project plan to request updates for tasks that are in progress however the form allows editing of all fields on the selected rows of the plan and I only want the recipient to be able to edit one or two of the fields. However, they do need to see all of the fields on that row. Is…
-
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........