-
If formula with several criteria
Hi, I was working on a formula last week, but I am still struggling with a second criteria on this. the way its set up, updating the field depending on dates being input into others. this works well as follows; =IFERROR(IF([Client review Required]@row = "Yes", IF([Actual Submit Date]@row = "", "Pending", (IF([Actual…
-
Combination of PARENT and LEFT function
Kia ora koutou, I'm wanting to combine the PARENT and LEFT functions to copy the first 6 characters of the Parent cell as a label for the Child cells. In my work, each parent cell starts with a code and then has a sentence (12+ words) as the title. I'd really like to be able to copy just the code e.g. A1.2.3 but not the…
-
Nested IF Help!
Hi all! I'm working on a formula that will give me the number of days a work item has been processing with our support team. I've identified the following variables: 1.) When {IT Ref #} is not blank, then I want to subtract two date columns ({Agility Creation Date} - {Created Date} 2.) When {IT Ref #} is blank, then I want…
-
Helper checkbox not working on reference sheet
I have multiple line items for a order in one sheet(Request Sheet) and in another sheet (Order sheet) where I have clubbed all the items in single row, based on the order ID from request sheet to order sheet I want to check the Quantity checkbox and update in the Order sheet, I tried index match formula but its not working…
-
IF/AND Formula help please
Hi all, Looking for some help with the following IF/AND Formula please which could result in the following answers: If Task Status not equal to "Completed" then return "Currently Incomplete" If Task Status not equal to "Completed" & the task is late( End date(actual)+Time Due(Actual) are greater than their targets, return…
-
Want to flag overlapping dates AND times
Based on information I've found here, I've created a formula that identifies overlapping times that occur on the same day, but I'd like to adapt it to incorporate items that occur over multiple days. This will be used for booking of equipment. Here is what I have so far: =IF(COUNTIFS(SAP:SAP, SAP@row, [Start Date]:[Start…
-
Change project status in Parent Row
I would like to change the parent row automatically if the status is changed other than "Planned" & "On Hold" in the status column, Please help me with the formula to achieve this. if all the tasks are completed it should change the status to completed otherwise it should be "in progress"
-
Stuck on IF, AND, and SUM formula
I am trying to create a semi-complex formula. I have two check boxes. When someone clicks check box "A", it sums up specific columns. When someone clicks check box "B", it sums up the other columns. When someone clicks both "A" and "B" check boxes, it'll sum up all of the columns. I am starting with this (I've edited the…
-
Index Collect Error
Hello! I am trying to use an INDEX COLLECT function to get a number value. It uses the following: Total number Filter of the Month Matches names between two sheets This is the formula I am using and it is returning an Incorrect Argument Set error. =INDEX(COLLECT({OPK Monthly Report 22-23 Unfilled 0-3}, {OPK Monthly Report…
-
Count Down Formula
Hi All, Does anyone have a formula that will count down to a specific date? Thank you.