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!

What is the best way to create a form, where you want to capture info on multiple occasions?
We are creating a three part learning series for HCP's and want to use one form to capture information presented during each visit. Is it possible to use a logical sequence only shows once each visit is entered? (Ex. Date 1, xyz presentation, then Date 2 is available to populate to enter xyz presentation) Or would I need…
iCal to Outlook - Filtered Calendar?
I have a sheet that collects information relevant to multiple people, think of these items as task assignments. I would like to have this integrated into each individual's Outlook calendar, but I want to filter it only to what pertains to them, is this possible? I understand it can't be done from a report. I also…
Hyperlinks Not Working
I have a weird situation. I have a hyperlink to a SharePoint site in a column. Each line has a different link. When you click the link, it does not work. When you copy the text and paste it in the browser, it works. I confirmed that the link text and the display text are the same. Any suggestions?