If statement with multiple conditions

Question

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" and [Documents Available]=true and [Checklist Complete]= false, "2 - Checklist Incomplete",If([Level]="Level 4" and [Documents Available]=true and [Checklist Complete]= true, "3 - Checklist Complete",If([Level]="Level 4" and [Documents Available]=true and [Checklist Complete]= true and [Approvals Needed]<>"", "4 - Waiting on Approvals",If([Level]="Level 4" and [Documents Available]=true and [Checklist Complete]= true and [Approvals Needed]="", "5 - Review Complete"------------------------------Sarah Burres------------------------------

MarkShnierYou · Answer

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
------------------------------

Sign up

Login to the community