-
How to automatically assign a Symbol when comparing two date columns?
This is what I got. =IF([Launch Date]@row >= [Estimated Delivery Date]@row, "Green", IF([Launch Date]@row < [Estimated Delivery Date]@row, "Red")) However, I want "Yellow" to be assigned when the [Estimated Delivery Date] is less than 30 days from the [Launch Date]. Appreciate the insight.
-
Determine if a Date is equal to or greater than 3 months ago
Looking for syntax help. I have columns (This Month, Last Month and Previous Month) to support some dashboard reporting IF statements. I am now looking to add a column called ">=3months" and I am unsure of the syntax. The syntax below is what I am using to determine Last Month: =IF(AND(MONTH([Record Date]@row) =…
-
Sum of True/False (1/0)
Hi, I am using this formula to search a multi-select column for if that column contains "IDS". =IF(CONTAINS("IDS", [Define Resource Needs]@row:[Define Resource Needs]@row), "1", "0") It is returning the 0 or 1 to me just fine - but what I want is a sum of the instances of "1". This will give me a count of how many times in…
-
SUMIFS & Specific Text/Quarter Requirement
I am trying to write a formula for a dashboard that sums the amount of money we spend a quarter based on a specific text. This is what I have so far and I'm getting "Invalid Operation". =SUMIFS{Log Sheet Range 2}, {Log Sheet Range 1}, CONTAINS("Pens", @cell), AND(({Log Sheet Range 7} = "Q2"))) Log Sheet Range 2 is the…
-
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…
