-
Nested formula with sheet references help
I need a formula that will: look up a name listed on sheet #1 on Sheet #2 and pull the most recent date they completed training. So far I have tried two formula combinations and neither has worked. =IF({Training Data Range 1 - Name} = Name@row, MAX({Training Data Range 2 - Date})) #INVALID OPERATION =VLOOKUP(Name@row,…
-
sum values of a column in another sheet based on the column position
Hi all, Is there any way to sum a certain column in another sheet based on the column position? I think of having a reference like {another sheet range} with a range of e.g. 4 columns. I would like to sum the values of the second column, but do not know how to make this. SUM(INDEX({another sheet range}, 2)) will not work,…
-
Want to Calculate Crew Required Based on Specific Dates
Below is the screenshot of the formula I am trying to use but it always returns 0, Please guide Thanks!
-
Formula for automatically pulling rows of data from one sheet to another using checkbox
Help please 🙏 I need a formula or solution for automatically pulling rows of data from one sheet to another using a checkbox... So sheet A has a ticked checkbox, meaning I need the information from most columns in the ticked rows moving over sheet B every time a sheet A checkbox has been ticked.... (I need name about 5…
-
Formula referencing another worksheet
Hi, I am trying to create a formula to determine how many tickets are in a Category and have a due date within the next 30 days. I am trying to do this outside of the worksheet so when creating my formula I need to reference back to this sheet, however no matter what I try I'm still having the same issues...…
-
Using INDEX/MATCH with images
Hi all, Is it possible to use an INDEX/MATCH formula to bring an image from one sheet into another? If not, anyone recommend a solution/ work around? I am building a new sheet that utilizes INDEX/MATCH to bring in info from several others and I would like to be able to bring in these images from their source document.…
-
Count Between Dates
Hello, I need a formula that identifies how many rows I have per quarter. Example; Q1 from Jan 1st to Mar 31 of this year. Some help Please
-
Cant get a countsif formula with multiple phase helper sections to work.
Hi I am trying to count project health indicators , But only i certain sections of my project plan. I can get a basic countsif formula to work: =COUNTIFS({Project Plan - Health}, =Metadata@row) + 0.0001 I can also get it to work with just one section : =COUNTIFS({Project Plan - Health}, =Metadata@row, {Project Plan - Phase…
-
Find and Return
Good morning gurus! I need some magic to find a return all instances of information in an external sheet. For example, I need to find all instances of "ABC" in the Material Name, and return the associated Batch number. All the formulas I try will give errors or only give me the data for one instance. Any ideas? Thanks in…
-
COUNTIFS on specific days and net change over time from report
Hello all, I am struggling on finding a solution for this. From our calendar, when we have issues, we log the issue in the notes section, categorize the main issue, and change the "Incomplete Job" column to Job down or go back. When the "Incomplete Job" changes, I have an automation to record the date in the column, "Date…