Formulas
Discussion List
- Column L44 with groups. ultimately ends up inside an if, but just trying base formula to eliminate everything else. #UNPARSEABLE =CONTAINS("In", CHILDREN(L44)) =CONTAINS("In", CHILDREN(L44@row)) #INVA…
- I am trying to create a formula across columns with different values in a cell. I have the formula for one value, Preliminary Draft. This works fine. =COUNTIFS({Comments Log Range 1}, [Document Name]@…
- 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 a…
- 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 a…
- 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, …
- 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 orde…
- 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 S…
- 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. …
- 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 ar…
- 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. W…