ContributionsMost RecentMost LikesSolutionsRe: If statement with multiple conditions THis worked! Thank you! ------------------------------ Sarah Burres ------------------------------ 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 ------------------------------ Action Help Where does the Report Link come from? How can I tie Number to Number? ------------------------------ Sarah Burres ------------------------------ Multi-file UploadUsing 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 ------------------------------ Calculating Percent differenceI have Utility usage (electricity, nat gas, water) for 2021 and 2022. What I would like to do is compare the two years and do a percent difference for each plant. Any ideas how to do that? The calculation is easy but how can I get Jan 2021 electricity for a plant on the record for Jan 2022? ------------------------------ Sarah Burres ------------------------------ html for multi select dropdown listTrying to create a multi select drop down html to use in a form. I did the wizard which created this: <tr><td class=m>Impact</td> <td class=m><select name=_fid_214 ><option>Improve Safety</option> <option>Improve Quality</option> <option>Improve Efficiency/ Reduce LH</option> <option>Reduce Maintenance and Repair Cost</option> <option>Reduce Scrap or Material Cost</option> <option>Promotes Environmental, Social, Governance (ESG)</option> <option>Less Physically Demanding</option> <option>Other</option> This only allows the user to select one and they need to be allowed to select multiple. Help! ------------------------------ Sarah Burres ------------------------------ Re: Code Form is not workingI fixed it. thanks ------------------------------ Sarah Burres ------------------------------ Re: Create a string of If CheckedWorked Perfect. Thanks! ------------------------------ Sarah Burres ------------------------------