-
Vlookup formula help
Hello - I created a summary sheet using the vlookup formula referencing another sheet. However, how do I show two amounts from two different rows in the source sheet where one row is the parent and one row is the child? I got it to show one of the values (the one from the PARENT row), but I need it to show both amounts in…
-
VLOOKUP Formula?
Hello, I need help with creating a formula that captures two criteria: 1- It assigns a score based on the type of incident. 2- If multiple incidents are logged in a single cell (via a multiple-choice dropdown), the score assigned will correspond to the incident with the lowest weight. For example, if two incidents are…
-
How to calculate certain items for a given fiscal year.
I am trying to count (COUNTIFS) during a given fiscal year. My fiscal year runs from the month of July - June, so currently I am in fiscal year 2024-2025. Column Fiscal Year = Dropdown Column Activity = Text Column Activity Type = Text Column Total = Text with calculation If I change the Fiscal Year the Total column should…
-
Formula not counting correctly
Hi Guys Please note the formula. see pic1 I am trying to count BS Numbers excluding zeros and blanks Pic1 However it's not returning the correct count, for some reason the formula is not counting some of the BS Numbers, see pic 2, the ones i circled in blue (see pic2), for formula is not counting them, i want the formula…
-
Monthly Automation report sends out last months data
I have a simple automation that looks at an employee sheet. On the 1st day of each month at 10am Central a report is sent to my email that SHOULD show the current months work anniversaries. However, every month I receive the email on the first of the month and it shows the PRIOR month anniversaries. Within the sheet I am…
-
Dashboard data not refreshing?
I have created a Dashboard where I’m using the chart widget, the data is being pulled from a sheet (sheet 2), were I pull data from a different sheet using formulas (sheet 1) to be used on the Dashboard. Sheet 2 is only used for calculations and counting for specific models of our department as Sheet 1 is a global sheet…
-
Consolodating rows with the same primary column
My company is looking to replace an Excel spreadsheet that we use to record the results of an order report in SAP. The problem we have is that SAP populates each order by the lines on that order. So for example; if an order has 8 lines on it, it lists that order 8 times with the quantity of each line rather than showing…
-
Tricky Formula - Need Help
I need help in figuring out a more complex formula. Below is a screenshot of my sheet. What I'm hoping to devise is a formula to go into the yellow highlighted cells (a unique formula for each column, I expect) that essentially tells me: Based on "Deadline@row" and "Remaining Hours@row", how many hours will have to be…
-
Return Value if Between Dates
Hello! I have a [DATE SUBMITTED] column and need to create a reference column that returns the fiscal year that date falls in. Something like this - =IF [DATE SUBMITTED] > 10/01/17 AND [DATE SUBMITTED] < 09/30/18 RETURN "FY18" and =IF [DATE SUBMITTED] > 10/01/18 AND [DATE SUBMITTED] < 09/30/19 RETURN "FY19" I'm not sure if…
-
Sheet Summary Fields in Notifications
Is there a way to add sheet summary fields in a notification? It is possible to add cells by using {{Field}} but this doesn't work for the summary fields. Any inputs are much appreciated.
