Looking for Help on multiple criteria IF formula using full columns
Hoping someone can help:
If conditions meet the below criteria, then Program Health result be be "Red" if not result would be "Green"
1st Requirement: Column "Essentiality" = "No-Go"
2nd Requirement: Column "Status" has at least one "Red" OR Column "Status" has 3 or more "Yellow"
Sorry I am new to smartsheet and struggling to figure this out.
Answers
-
@bethvalen1_pk5 You are showing that your formula is #unparseable. Please start with posting your current formula and we'll see about adjusting from there.
Darren Mullen, Author of: Smartsheet Architecture Solutions
Get my 7 Smartsheet tips here
Take your Smartsheet knowledge to the next level and become an expert. Join the Smartsheet Guru Elite
-
Hi Darren, please see below, I know this is not correct but as close as I could get
=if(AND(Essentiality:Essentiality)="No-Go", (Status:Status) >=1 "Red", "Red", "Green")
Help Article Resources
Categories
Check out the Formula Handbook template!