-
Formula Needed. - IF Blank, then Index another cell
Hi, I am looking for some help with a formula. I need a formula that will "pull/copy" the date entered in the column titled REV. START DATE. However, if the REV. START DATE is blank, then I need it to pull the date from the ORIGINAL START DATE column located on the same row. I was originally using the =MAX([Original Start…
-
Vlookup from two Sheets into one sheet
Good day, Im trying to do a Vlookup from two sheets into one cell. If the 1st sheet data is not a match, it will give an error, then I want the sheet to look at the different sheet for the needed data. Im trying something like this but getting a #UNPARSEABLE error =IFERROR(VLOOKUP([TRIP REF]@row, {Master Sheet - A Range…
-
I am trying to get the last Monday of the month from a date using a formula.
I am working on a project where I want to use a formula to return the date of the last Monday in a month. For example, if I have a cell that says 4/11/2024, I want a formula that will then return 4/29/24 (because that is the final Monday of this month).
-
List of Same Project name with unique date.
I have four column as show in table below columns. I have one text/number column two date and one duration. "I have nearly 500 projects in my database. Some of these projects share similar names, and among them, certain projects have distinct submission dates despite having the same name. I need to compile a list of…
-
Find words starting with capital letters
Hello, I have a column (Species) where I have some species names e.g. Pseudomonas uno, Bacillus due, Vibrio tre - in the same cell. I want to create another column where I only have the info of the words with capital letter (Genus) filtered i.e. Pseudomonas, Bacillus, Vibrio. Right now I have a formula that allows me to…
-
Multi-Select formula using the selections as the criteria.
See attached document for details, but I need to select email addresses from an external sheet where the contents of a multi-select column is used as the criteria. This was my attempt. No errors, but it doesn't return anything. =JOIN(COLLECT({Email Address}, {Dealer Name}, HAS(@cell, DEALER@row)), CHAR(10))
-
Looking for a formular to help with a rooming list...
I have lots of passengers on separate rows. I have a heading row of dates. I then have a sequence of 1's in a grid that show which nights a person will check in for 1 over night stay. In the first example, my traveller will check in on 17/06 and check out on 24/06. I am currently having to update the columns manually when…
-
Sum IF Help With a Formula - I think it is SumIF
Hello all, I have a sheet with a column that has this formula in a column labeled "This Month Available Hrs Remaining" =NETWORKDAYS(TODAY(), IFERROR(DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1) - 1, DATE(YEAR(TODAY()) + 1, MONTH(TODAY()) - 11, 1) - 1)) * 8 * Count@row This formula lets me know how many man hours I have…
-
How to return the value of an adjacent cell for a summary sheet to show phase or step in a process
How can i use an IF statement to return the value of the adjacent cell in the PHASE column for a status cell that is IN-PROCESS. Or is there an easier way? For any Status of IN-PROGRESS, i want to return the Adjacent same row Phase value. From below something like: If Status column = IN-PROGRESS then show Phase column…
-
Need help with creating formula/function to determine asset availability
Hi All! This is what I am trying to achieve: I would like to add a function or formula in 'Availability' column to determine if the Vessel(s) selected in 'Vessel Type' column are available or not for newly 'Submitted' rows. Condition to check availability: Compare Start Date and End Date for Vessel(s) in 'Submitted' with…