Here is the current IF statement string that I have; however the results are not providing what I want... In essence the formula is working but not entirely... For all statements true, I want the related result to display in the calculated column. Right now, only the first result is showing... For example, I am expecting to see: Phone System, ACT!, F5 Pool Node, etc. in the calculated column results but only seeing "Phone System" displaying. All fields are a drop-down menu field providing the choice of either Yes or No from the field. These are not checkboxes or radial button fields.
Okay... I am figuring this out after reading a few postings about IF statement limitations in calculated fields... (something about only 7 IF statements in groups)... and how to adjust for that... That allowed me to modify the entire formula to get it to return all the appropriate line items based on them being "Yes" or "No"... In my test example, all 19 answers should return which is what is occurring now... However, I now need to figure out how to get a "line break" or return between each response so that I see a stacked list response...
Any help would be appreciated!!
= IF([Phone System Completed]="Phone System<br/>","") & IF([ACT Completed]="ACT<br/>","") & IF([F5 Pool Completed]="F5 Pool Node<br/>","")