Forum Discussion

SarahBurres's avatar
SarahBurres
Qrew Trainee
2 years ago

If statement with multiple conditions

Formula goes up to "3- Checklist Complete" but stops there and I cannot figure it out.   If([Level]="Level 4" and [Documents Available]=false, "1 - Waiting on Documentation", If([Level]="Level 4" ...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 years ago

Unlike Excel you generally don't need to nest your IFs. You just list the conditions and the formula will keep checking them in sequence and use the reduk5 for the first condition which is true. 

Formula goes up to "3- Checklist Complete" but stops there and I cannot figure it out.  

Try this 

IF(

[Level]="Level 4" and [Documents Available]=false, "1 - Waiting on Documentation",
[Level]="Level 4" and [Documents Available]=true and [Checklist Complete]= false, "2 - Checklist Incomplete",
[Level]="Level 4" and [Documents Available]=true and [Checklist Complete]= true, "3 - Checklist Complete",
[Level]="Level 4" and [Documents Available]=true and [Checklist Complete]= true and [Approvals Needed]<>"", "4 - Waiting on Approvals",
[Level]="Level 4" and [Documents Available]=true and [Checklist Complete]= true and [Approvals Needed]="", "5 - Review Complete")


------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
SarahBurres's avatar
SarahBurres
Qrew Trainee
2 years ago

Didn't work. 

 

Here is the entire formula.  The other Levels work but not Level 4.

 

If([Level]="Level 1" and [Documents Available]=false, "1 - Waiting on Documentation",

[Level]="Level 1" and [Documents Available]=true and [Approvals Needed]<>"", "2 - Waiting on Approvals",

[Level]="Level 1" and [Documents Available]=true and [Approvals Needed]="", "3 - Review Complete",

 

If([Level]="Level 2" and [Documents Available]=false, "1 - Waiting on Documentation",

[Level]="Level 2" and [Documents Available]=true and [Approvals Needed]<>"", "2 - Waiting on Approvals",

[Level]="Level 2" and [Documents Available]=true and [Approvals Needed]="", "3 - Review Complete",

 

If([Level]="Level 3" and [Documents Available]=false, "1 - Waiting on Documentation",

[Level]="Level 3" and [Documents Available]=true and [Approvals Needed]<>"", "2 - Waiting on Approvals",

[Level]="Level 3" and [Documents Available]=true and [Approvals Needed]="", "3 - Review Complete",

 

If(

[Level]="Level 4" and [Documents Available]=false, "1 - Waiting on Documentation",

[Level]="Level 4" and [Documents Available]=true and [Checklist Complete]= false, "2 - Checklist Incomplete",

[Level]="Level 4" and [Documents Available]=true and [Checklist Complete]= true, "3 - Checklist Complete",

[Level]="Level 4" and [Documents Available]=true and [Checklist Complete]= true and [Approvals Needed]<>"", "4 - Waiting on Approvals",

[Level]="Level 4" and [Documents Available]=true and [Checklist Complete]= true and [Approvals Needed]="", "5 - Review Complete")

 

 

)))