0

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. enter image description here 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.

  • 1
    Start of by pasting the Formula in notepad, add plenty of linebreaks and tabs to format your code. You can paste the formula in SP, it will ignore all formatting. Add an extra tab in front of each line and paste your code in this post so we can actually read what your trying to do (no one is going to try and understand what you posted now) – Danny '365CSI' Engelman Feb 11 '16 at 17:59
  • 1
    If you want to see output like Phone System, ACT!, F5 Pool Node you'd need to concatenate together, you just have a bunch of ifs evaluating field values. I'm guessing you are seeing what you are seeing because the first thing evaluates to true and ends. – Eric Alexander Feb 11 '16 at 18:51
  • Thanks Eric... you appear to be following where I am trying to go with this... I am now trying to CONCATENATE the IF statement formula above and no changes are occurring... still only seeing the first IF statement response displaying when in my test example the entire formula should return all 19 items listed... I am wanting to see all items listed one below the other (with line breaks after each one)... So still stumped. What am I missing? – T. Adams Feb 11 '16 at 20:49
0
=
IF([Phone Sys Completed]="Yes","Phone System<br/>","")
&
IF([ACT Completed]="Yes","ACT<br/>","")
&
IF([F5 Pool Completed]="Yes","F5 Pool Node<br/>","")

... and so forth.

Calculated field settings:

enter image description here

Results:

enter image description here

  • SP is not liking that... but the following (or above) is accepted but not returning the correct results... – T. Adams Feb 23 '16 at 20:41
  • Are they checkbox fields? – Erin L Feb 23 '16 at 21:57
  • No they are not checkboxes... all of the fields in question are a drop-down field for the user to select either Yes or No... In this particular calculation, do they need to be checkboxes or radio buttons for a more "truer" TRUE/FALSE situation? – T. Adams Feb 24 '16 at 15:03
  • I had a typo... the first field should be [Phone Sys Completed] instead of with the full word "System," right? I'll edit it for that, but otherwise this formula works for me. SharePoint accepted it fine. So check that my field names match yours. – Erin L Feb 24 '16 at 15:52
  • That's not the issue... it is already corrected in the current formula as I validated that already... but it is still giving back the error of #VALUE!.. SharePoint accepts the formula but the results are still showing the #VALUE!... – T. Adams Feb 24 '16 at 17:27
0

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!!

  • Can anyone in this discussion board provide guidance on how to get line breaks into the formula so that it displays a stacked list of expected results? – T. Adams Feb 16 '16 at 17:12
  • Add <br/> to your calculated field, then return the calculated field as a number instead of a single line of text. – Erin L Feb 23 '16 at 17:02
  • thanks Erin... tried adding <br/> at the end of each IF statement but it didn't like it... also I updated the image snapshot of the formula to the current version prior to your comment... what am I doing wrong? – T. Adams Feb 23 '16 at 19:47
  • Are you still getting only one value? – Erin L Feb 23 '16 at 20:05
  • yes currently I am only getting the first value returned even though all values are selected as "Yes"... and if I remove the ," " from the end of each IF statement, then all values return even though the formula as it shows above is accepted currently... if the IF statement does not equal "Yes" then I want it to return nothing or a blank and then assess the next statement and so on... A little frustrating to say the least... Tnx – T. Adams Feb 23 '16 at 20:11
0
 =
 IF([Phone System Completed]="Phone System<br/>","")
 &
 IF([ACT Completed]="ACT<br/>","")
 &
 IF([F5 Pool Completed]="F5 Pool Node<br/>","")
  • Please consider adding some description along with the code. – Asad Refai Feb 24 '16 at 5:39
  • Hello Asad... please read through the entire thread of discussion as I believe I have provided enough description as to what the intended results are. Thnx – T. Adams Feb 24 '16 at 14:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.