AND OR + IS BEFORE IF statement help

[Meri_Wilson]

Hi there! I’m trying to do a fairly simple formula but it has quite a lot of conditions. I’m a beginner and not sure where I’m going wrong, could someone help?

The board is a basic project overview. I’m trying to set a column to display “on track” or “overdue” depending on what the due date and status of the item is.

My current formula is written like so:

IF(
AND(IS_BEFORE(Due,TODAY(),
IF(
OR(
Status = “In Progress”,
Status = “With Client”,
Status = “Not yet started”,
),
“Overdue!”,
“On track”
)))

Any help would be greatly appreciated!

Meri

[augmented]

Hi Meri. I gather than you want to check for two things being true: 1) due date is in the past and 2) some status is one of three items. If so, the task/proj is overdue. First problem I saw is that your IS_BEFORE is not closed off with a needed right paren. Then, you don’t need the second if. Try this…

IF(
AND(
   IS_BEFORE(Due,TODAY()),
   OR(
    Status = 'In Progress',
    Status = 'With Client',
    Status = 'Not yet started',
   )
),
'Overdue!',
'On track'
)

[Meri_Wilson]

Hi augmented, thank you so much!
That is exactly what I’m attempting yes.
Unfortunately this is still giving me an error saying invalid formula - any ideas? I also checked the capitalisation of the Status options in case that was messing with things, and removed some spaces but that didn’t help. Been banging my head against this for ages!

[augmented · Accepted solution]

My fault Meri. There’s an extra comma after ‘Not yet started’ that needs to be removed. :man_facepalming:

[Meri_Wilson]

augmented:

IF(
AND(
   IS_BEFORE(Due,TODAY()),
   OR(
    Status = 'In Progress',
    Status = 'With Client',
    Status = 'Not yet started',
   )
),
'Overdue!',
'On track'
)

Ah perfect! Thank you so much for your help, and this has helped me understand the syntax much better!