# AND OR + IS BEFORE IF statement help

Topic Labels: Formulas
Solved
1409 4
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

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

1 Solution

Accepted Solutions
10 - Mercury

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

4 Replies 4
10 - Mercury

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'
)
``````
5 - Automation Enthusiast

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!

10 - Mercury

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

5 - Automation Enthusiast

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