-
How to use Index(Collect(....
I'm trying to build a summary sheet that will pull values from a task list. How do I have the values in row 1 of the summary sheet reference the corresponding values under the 12345 parent. I think that INDEX and COLLECT are the tools I need but I don't know where to start.
-
Formula issue
Hi Braine Trust I need some help with a formula I have Mobilization Date and need to create reports that will show me a list of people who have mobilized - Any one Mobing Week Prior to the Mob Date Any one Mobing The Week of the Mob Date A 2 week Forecast ( so two weeks prior to the Mob Date A 3 week forecast (so three…
-
IF Statement to Display Symbols
Formula variable question for an IF Statement. Ok I have 5 columns (see screenshot below). This formula will be added to the one on the far right (Certification Complete). Now I would like to assign a value to each to trigger the symbol that will display. Basically the way it works is that all 5 columns are required, if…
-
UNPARSEABLE Error for Countif of overbudget tasks
Hello all! I'm trying to calculate the number of the overbudget tasks in my sheet summary. I have a column that is Actual Cost, and another column that is Budget. The AI suggested formula was: =COUNTIF([Actual Cost]:[Actual Cost], >[Budget]@row) But when I hit enter, I receive the unparseable error. Could anyone help me…
-
VLOOKUP and dropdowns
Hi! I'm trying to return a date from a VLOOKUP but the search is in a dropdown. It is saying no match despite the name being in the sheet. Does my information have to switch out of a dropdown for this function to work?
-
Help with IF formula returning "invalid operation" message
I am applying this formula and get an "invalid operation" return message. Essentially, I need a function that checks if the latest or most recent date in which a member was met by Sales team is greater than 1st of Jan 2024 . In such case, it should return "Yes" and if not it should return "No". Can somebody assist with the…
-
INDEX MATCH Formula help
Hi I'm looking for help with a formula. I've gotten some of it written but I'm missing something. I have a "Mastersheet" where my form responses are held. Then depending on the form originator the row is copied to a new sheet. The new sheet will be where tasks are worked on and completed. I have a "Record Closed Out?"…
-
Calculate first working day of a month
Hello I need 2 formulas please to calculate (1) the first working day of a month So - 1 December 2024 is on a Sunday, I want the returned date to be 2 December 2024. 1 November 2024 is on a Friday, I want returned date to be 1 November 2024. (2) the first Thursday of a month So for December 2024, the returned date should…
-
Index Collect criteria with MAX latest date
Hi, I've been hitting myself over the head for not 'getting' it, I think i'm doing the correct thing, but obviously since I'm reaching out, I am NOT ;) If you would be so kind, please enlighten me on my error. In a sheet summary I'm trying to do the following: =INDEX(COLLECT(ReportSummary:ReportSummary;…
-
Countifs date is this month and a day of the month
Hello all, I am using the formula to count from a list of dates in another sheet to find all entries that are from this month. =COUNTIFS({Date}, IFERROR(MONTH(@cell ), 0) = MONTH(TODAY()), {Bay}, Bay@row) I would like it to also register if it is the 1st of the month (for the column named 1st) and the 2nd of the month (for…