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!

Dashboard
Hi Team, I'm having trouble pulling data from a sheet into a dashboard, it won't let me select the tabs I'd like to use. Any tips?
Guest User with Admin Permissions is unable to edit a Dashboard
I am the owner of a workspace that has multiple sheets and a dashboard. There are 3 Guests with Admin permissions for the whole workspace. They can edit the sheets, but not the dashboard. Is there a different type of permissions or some kind of limitations to dashboard editing for Guests?
Use of Contact List not working today
I downloaded the request engagement template(s) and modified them for my business. Yesterday use of a contact list for notification was working, today it's not. I have recreated the workflow from scratch and added a new contact list column as suggested in blogs sequentially. Still not working. What does work is when I…