-
Join Collect formula that excludes the current row from the results
I'm trying to create a formula that creates a list of duplicates in my sheets, I've gotten this formula to work but it's showing the original row within the list of duplicates. I tried adding an auto number column and including a condition that the list shouldn't include the current row. However, the addition of this to…
-
Form Submissions: Multiple Condition IF Formula Isolated to Most Recent Only
Hello Friends! I have a form that my field crew uses to check the condition of our machines every morning, which includes the most recent hour/meter reading. There are (5) machines that we own that I want to isolate the most recent reading into a dedicated cell in order to determine how soon the next service will be. Also,…
-
Nested IF/CountIF Help
Hi! I am currently building a dashboard to show reporting on employee injuries for cases that are not resolved. I am having trouble with my formula and have been spinning my wheels. I need the formula to look at my reference data and, if the checkbox in the 'Done' column is not marked, then return the incident type into my…
-
Please could someone kindly help fix IF/INDEX/MATCH formula
Hello I need a little help if possible Original Formula: =INDEX({Jira MMP's Validation Results - Jira Status}, MATCH([Req ID]@row, {Jira MMP's Validation Results - MMP ID}, 0)) Which worked perfectly to change the status in sheet 2 to match sheet 1 if REQ ID and MMP ID matched, but this is when there was only a single set…
-
Require all approvals received before setting status to Approved
I have this successfully working column formula in Overall Approval Status: =IF(COUNTIF([Approval - Kashif]@row:[Approval - Adam]@row, "Declined") > 0, "Declined", IF(COUNTIF([Approval - Kashif]@row:[Approval - Adam]@row, "Approved") > 0, "Approved", IF([TEAM A - Approval Requested]@row = 1, "Submitted", ""))) From AI: The…
-
Unparsable IF( & Gantt
I'm trying to make my Gantt display carry my current projects out with a hidden "completion date" row and IF= code, but it won't work. If my unhidden completion date cell is blank, I want it to autofill todays date so my gantt will show current projects, but if my viewable completion cell has a date in it, I want it to…
-
COUNTIF in an IF formula
I am trying to see when a segment is fully completed. Our segments can be broken out into subsegments, and they can have up to 5 subsegments, indicated by the segment number followed by a "—1", "—2", and so on. So far for this formula I've gotten it to count how many subsegments there are, but can't get the final push of…
-
How can I get the IF command to leave False portion alone and complete the formula
This is to track mileage being run on a vehicle as invoices come in. If the number is negative I want it to say "Mileage not Recorded" But currently it will leave blank all the cells with positive numbers that I need to be there. How can I get this to do nothing for the false portion? =IF(Mileage@row - (INDEX({Donated…
-
Nesting IF/OR Statement(s)
I'd like to combine multiple IF/OR statements so when I update my status column another column will auto update: When Status is Complete or Received list Full, if not, list Empty; when Status is In Process or Quoted list Quarter, if not, list Empty; when Status is Dispatched or Ordered list Half, if not, list Empty. Is…
-
If between 2 numbers, then
I'm sure there's a simple way to do this, but I can't figure it out without going through each number, 1 by 1. I have 48 numbers, so it would be lengthy. If cell = the below, return the size. It is a set cell for the number and a set cell for the formula. 1 = XS 2-6 = S 7-10 = M 11-24 = L 25-48 = XL >48 = XXL I greatly…
