Help

Re: AND OR + IS BEFORE IF statement help

Solved
Jump to Solution
621 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Meri_Wilson
5 - Automation Enthusiast
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

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

See Solution in Thread

4 Replies 4
augmented
10 - Mercury
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'
)

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!

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

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