-
How can I get the sum of one column meeting two conditions
Trying to get multiple conditions and sum up total billable. Where Manager = John Smith in one column and Invoice Date = January in another column Getting the #UNPARSEABLE error =SUMIFS(AND(Manager:Manager, "John Smith", Invoice Date:Invoice Date, MONTH(@cell) = 1), [Billable Total]:[Billable Total])
-
Formula Help - Remaining Hours To Be Worked In A Term, Equally Spaced Out Monthly
All, You've always been good to me. I'm hoping to get across the finish line for a formula I've been working on. Here's what I have: * Start Date, End Date, Working Days within that range (could be one week, could be ten years) * Remaining Hours (total hours necessary to be worked within the Start & End Date) I need a…
-
Comparing multiple data sets
Hi all, I'm attempting to compare data sets between 3 different sheets. Basically I want to compare our internal data to the clients data. The common denominator between all 3 sheets is a claim number, the dates in the columns though will likely be different, and my goal is to identify which claim numbers have dates that…
-
Index Match dilemma
I am attempting to access info from another sheet. I have a list and need to attach the correct person to the item. I've tried 2 different formulas, but it's only bringing back the 1st person that it found, not a different person for each item. Here are the 2 formulas that I've tried. What am I missing? =INDEX({TO CHECKOUT…
-
Status Formulas
Hi. First time here. Sorry if this is not the correct avenue. I need a formula for a "Complete", "In Progress", and "Not Started". If start date is blank then the status should be "Not Started". If there is a start data then it should be in progress. If the completed date is entered status should be "complete"
-
Employee Main List Formula Modification
I am currently using the Return to Workplace template set. I want to modify the formula being used on the Employee Main List Sheet to only collect trainings attended if the column next to it says a specific project phase (Dropdown). I am dividing the trainings by phases but I don't want the Trainings Attended to account…
-
Countif based on array of values
Hello, I hope this is possible!🤣 I have this list of states where a "Task Name" can have multiple sub-states listed on "Column 1" I've already "merged" the sub-states. Example below with Blocker --> "Test Blocked" & "Blocked" =JOIN(COLLECT([Column 1]82:[Column 1]89, [Task Name]82:[Task Name]89, [Column 4]86), " ") and now…
-
VLOOKUP or INDEX MATCH Referencing Another Sheet
I would like to pull "Type" from a different sheet by matching the Project #. I've used both INDEX MATCH and VLOOKUP formulas which has worked well! Here are the formulas: =INDEX({program Intake Form Range 1}, MATCH([Project #]#, {program Intake Form Range 2}, 0)) =VLOOKUP([Project #]#, {program Intake Form Range 2}, 5,…
-
What formula do I use to calculate the number of years from a date till today?
=([Roof Install Date]@row - TODAY ()) / 365 I want this to be automatically calculated, but the formula posted on another post does not work. Please let me know how I can accomplish this. Thank you!
-
How to remove #Divide By when result is 0
This is my formula and the result is zero which is accurate, however the cell is displaying #DIVIDE BY. How can I change it to show 0% vs the error? =([Metric 1]@row / Totals@row)
