-
IF OR Formula
Can I get help with this formula? I need the answer to be 4 if either of these two columns are a yes. If both are a no, then I need the answer to be 0. If one is yes and one is no, then the answer still needs to be 4. =IF(OR([Innovate Audit]@row = "Yes", 4), ([Innovate Audit Included in Upgrade?]@row = "Yes", 4), 0)
-
Sequential Approvals with Missing Contacts
Hi All! I'm trying to build an automation that sends out approvals in sequence. If a contact column (1-3) is blank, it should skip to the next approver so the workflow can continue. As I understand the approval automation, it will run in sequence written, but if there's no contact assigned, then the workflow won't run or…
-
Issues with autogenerated Asset #'s
I am autogenerating an Asset # that combines a Product code with a number. Here is the formula I'm currently using (thanks to Community members who helped last year) and a screenshot of some sample data. =IF(COUNT(ANCESTORS([Deliverables and Tasks]@row)) = 2, (Product@row) + 10 + COUNT(DISTINCT([Asset #]$1:[Asset #]6)),…
-
Parents Misrepresenting Start & Finish Dates of Children
I have the Parent Rollup Functionality turned on as it is essential for my project to handle to dependencies. The problem I'm trying to overcome is that the Parent displays Target Start (TS) and Target Finish (TF) dates when not all children are populated in the same fields. If child#1 (of 2) has TS and TF dates populated,…
-
COUNTIFS formula - compare 2 date columns and count the ones that are in between the days 81-99?
I want to make a COUNTIFS formula that compares 2 date columns and count the ones that are in between 81 and 99 days. I would appreciate your help!
-
Formula for multiple criteria on summing up columns
Hi, all! Does anyone know the formula for multiple criteria to be met before adding column values up? The data set example follows. I need to be able to total up 7 cost types if they are either billable or not, expense or capital, one-time or ongoing cost. The sums I need to integrate are (1) total billable capital…
-
Multiplication of columns
Hi, I would like to multiply two columns together, however I keep getting an invalid response. Is this because the data in each of those columns is obtained through a formula? I need to multiply the value obtained through each formula to get my final answer but am not sure how to do that. For the initial formula, I was…
-
Nest If statements with countifs, contains, checkboxes.
Hi, I am trying to create a formula to update the status column. If ALL 5 people columns has any combination of "approved", "approved: with questions", "approved: with comments", then it marks the status Approved. If any of the 5 people columns has "In Review" or Reviewed: with questions", the status column in mark as "In…
-
I am trying to add 5 years to a date
I am using the following formula =DATE(YEAR([Activation Date]@row) + 5, MONTH([Activation Date]@row), DAY([Activation Date]@row)) The Activation Date column is set to a Date column Type The receiving column (Expiration Date) is also set to a Date column Type I am getting an error #UNPARSEABLE
-
Index match or collect
HI Experts, I try to set up a formula for below table. Blue Part is on another sheet, and I would like to show the correct awbif article is the same and "Name" is "Kerstin" in the yellow marked column "awb new sheet". I tried a few versions with Index and Match or collect, but without success. Would be great if you could…