nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

IF AND Formula Workaround

terrencekm

Hi All

I am trying to get a formula working whereby if

END DATE is in the next 3 days
END DATE is not blank
Status is either (In Progress, Not Started)
At Risk flag will be indicated (, 1)

Many thanks

Find more posts tagged with

Formulas

Comments

Paul Newcome

Give this a try...

=IF(AND(Status@row <> "Complete", [End Date]@row >= TODAY(-3)), 1)

L_123

=IF(AND([End Date]@row <= TODAY() + 3, NOT(ISBLANK([End Date]@row)), OR(Status@row = "In Progress", Status@row = "Not Started")), 1, 0)

Broken down:

=IF(

3 Criteria AND statement

AND(

First criteria end date is within next three days or in the past

[End Date]@row <= TODAY() + 3,

Second criteria end date is not blank

NOT(ISBLANK([End Date]@row)),

Third criteria: opens or statement that returns a true if status is in progress or not started

OR(

Status@row = "In Progress",

Status@row = "Not Started")

Returns 1 if criteria is met, 0 if not.

1, 0)

Sign in to join the conversation!

Quick Links

Trending discussions

Expense columns are not syncing
The formula has been corrupted and all we have are 0's. They are in our PO Expenses but not syncing with the job.
Trying to build a helper column to identify duplicate values but the cell value returns "NO MATCH"
I am trying build a helper column which will be ticked if the value under the column PROP_CD has a duplicate. I am currently using this formula =IF(COUNTIFS([PROP_CD]:[PROP_CD], [PROP_CD]@row) > 1, 1, 0), but all the cells return error "NO MATCH" Would appreciate any help or insight…
Month End Checklist Notifications
Hi all, I'm building out a month-end checklist for a department and they want to be reminded on Day 1 of every month to start their tasks and on Day 10 to complete their tasks. I was able to create a simple workflow that on Day 1 and Day 10 of every month, it sends them a reminder, however, they have asked if day 1 or 10…