Ok, I've been working on this most of yesterday and today. I am able to render an image with the following formula -

    ="<div><img src='/xx/xx/PublishingImages/"&IF([Employees Submitted On Time PP1]="Yes","anchor.jpg'> ","hyphen.jpg'>")&"</div>"

But it either picks "yes", or no and blank.

I need to add a "NO" in there and I've tried several formulas, including this one.

    ="<div><img src='/xx/xxx/PublishingImages/"&IF(OR[Employees Submitted On Time PP1]="Yes","anchor.jpg', [Employees Submitted On Time PP1]="No","red-no.jpg'> ","hyphen.jpg'>")&"</div>"

Any help would be greatly appreciated.

="<div><img src='/xx/xxx/PublishingImages/"
&IF(OR[Employees Submitted On Time PP1]="Yes"
    ,"anchor.jpg', [Employees Submitted On Time PP1]="No"
    ,"red-no.jpg'> ","hyphen.jpg'>")&"</div>"

All I did was copy your Formula and added some line breaks to see where you put all the "

That is where you are going wrong

  • " quotes in the wrong places
  • The OR function has missing/misplaced ()

I presume you want:

="<img src='/xx/xxx/PublishingImages/"
&IF(ISBLANK([Employees Submitted On Time PP1])
    ,IF([Employees Submitted On Time PP1]
| improve this answer | |

Try this below one, if you have used Yes/No column

="<DIV><img src='"&IF([Completed?], "/_layouts/images/KPIDefault-
0.GIF", "/_layouts/images/KPIDefault-2.GIF")&"'></DIV>"

Ref : http://www.dreamsharepoint.com/sharepoint-2010-simple-kpi-using-calculated-columns/

| improve this answer | |

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.