SarahBurres
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: If statement with multiple conditions
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") )))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" 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 ------------------------------If statement not working
If(IsNull([Related Order]) & [Type]="Non-conformance Report (NCR)","NCR-"&[Tag]&"-"&If(IsNull([Snapshot]),[Snapshot Override],[Snapshot]), If(IsNull([Related Order]) & [Type]="Material Problem Report (MPR)","MPR-"&[Tag]&"-"&If(IsNull([Snapshot]),[Snapshot Override],[Snapshot]), If((not IsNull([Related Order]) & [Type]="Non-conformance Report (NCR)","NCR-"&[Plant Number]&"-"&If(IsNull([Snapshot]),[Snapshot Override],[Snapshot]), If((not IsNull([Related Order]) & [Type]="Material Problem Report (MPR)","MPR-"&[Plant Number]&"-"&If(IsNull([Snapshot]),[Snapshot Override],[Snapshot])))))) ------------------------------ Sarah Burres ------------------------------Multi-file Upload
Using magic buttons to upload multiple files and it is working great. I have one app that I would like to do the same but the files have a type associated with it. For example, I need to upload 10 files and chose the file type as "drawing" or "email". Any suggestions on how I do that? ------------------------------ Sarah Burres ------------------------------
