SVP Product Strategy

Matt Pinkston

<div>
<div class="content wysiwyg-content">
I have been using the following calculated field formula which has worked great but I have been giver a new wrinkle.... 
 
=IF(AND(status_finance=&quot;complete&quot;,status_cnl=&quot;complete&quot;,status_solution=&quot;complete&quot;,status_hr=&quot;complete&quot;),&quot;complete&quot;,&quot;initial&quot;) 
 
now I need to mark complete if 
status_finance = complete and status_cnl = complete and status_solution = complete or N/A and status_hr = complete or N/A
</div>
</div>

I have been using the following calculated field formula which has worked great but I have been giver a new wrinkle....

=IF(AND(status_finance="complete",status_cnl="complete",status_solution="complete",status_hr="complete"),"complete","initial")

now I need to mark complete if 
status_finance = complete and status_cnl = complete and status_solution = complete or N/A and status_hr = complete or N/A

Need to add OR to a working calculated field formula

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.