Welcome!

if function for 3 criteria

Dear,

I am planning to write an if function for 3 criteria.

IF(AND([In Progress - Late]1 >= 1, [At Risk]1 >= 1),[In Progress - On Track]1>=1,) "Red","")

I know I am writing it wrong. Can anyone help me structure the formula please?

Cheers!

Hi,

What column types are you using?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help.

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

You just misplaced a comma is all...

On Track]1>=1,) "Red"

move the comma to the other side of the parenthesis.

On Track]1>=1), "Red"

Cheers mate for spotting that error.

Cheers for your response, the problem is solved.

I'm always happy to help!

Have a fantastic weekend!

Best,

Andrée

Happy to help!

Email attachment
With the automated email function is there a way to edit how the email is designed? Our accounting system does not pick up the pdf link and will only recognise a Pdf as an attachment? Thank you in advance
How do I log in when it says I have no account?
When I try log in and request a code I get an email to say I do not have an account, when I try to create an account I get an email to say I already have one and to log in. I have tried logging in via password no help , I have tried to change my password no help.
Sorting stopped working on existing sheet
Hi, I saw a few posts about sorting not working properly, but none of them had a solution and I'm not sure if my issue is the same. A sheet I have been using and adding and removing rows to/from over the last 6 months suddenly stopped sorting the date column in ascending order for new rows. No hierarchy or filters in…