Forum Discussion
Complex IF function application
Hello, My team uses SharePoint to track multi-step projects from scheduling to completion. We are building a resource loading feature into this tracker. To do this, we have assigned Phase design...
paccagnd If you know the right combination of conditions, you should be able to achieve it using SharePoint calculated formula.
Check my answer here to know more about nested conditions & number of characters limitation in calculated formula and workaround: What is the maximum syntax formulas that I can use in calculated column on my SharePoint list?
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs
- This is the current formula we are using: =IF(AND([Site Prep Status]="Not Started",[Protocol Pre-Approval Status]="Not Started",[DIRA Status]="Not Started",[SOP Status]="Not Applicable",[LCS Protocol Status]="Not Started",[LDM Protocol Status]="Not Started",[Qual Report Status]="Not Started",[Eq Release Date]=""),"Phase 0",IF(AND([Site Prep Status]="Completed",[Protocol Pre-Approval Status]="Approved",[DIRA Status]="Not Started",[SOP Status]="Not Started",[LCS Protocol Status]="Not Started",[LDM Protocol Status]="Not Started",[Qual Report Status]="Not Started",[Eq Release Date]=""),"Phase 1",IF(AND([Site Prep Status]="Completed",[Protocol Pre-Approval Status]="Approved",[DIRA Status]="Completed",[SOP Status]="In Review",[LCS Protocol Status]="Completed",[LDM Protocol Status]="Completed",[Qual Report Status]="Not Started",[Eq Release Date]=""),"Phase 2",IF(AND([Site Prep Status]="Completed",[Protocol Pre-Approval Status]="Approved",[DIRA Status]="Approved",[SOP Status]="Approved",[LCS Protocol Status]="Completed",[LDM Protocol Status]="Completed",[Qual Report Status]="Not Started",[Eq Release Date]=""),"Phase 3",IF(AND([Site Prep Status]="Completed",[Protocol Pre-Approval Status]="Approved",[DIRA Status]="Approved",[SOP Status]="Approved",[LCS Protocol Status]="Completed",[LDM Protocol Status]="Completed",[Qual Report Status]="Approved",[Eq Release Date]=""),"Phase 4",IF(AND([Site Prep Status]="Completed",[Protocol Pre-Approval Status]="Approved",[DIRA Status]="Approved",[SOP Status]="Approved",[LCS Protocol Status]="Completed",[LDM Protocol Status]="Completed",[Qual Report Status]="Approved",[Eq Release Date]<>""),"Phase 5",""))))))
The issue is that for each Phase, there may be more than one combination of conditions and I'm not sure how to adjust this formula to add that complexity.
