Why does SharePoint not understand to change the image when I use If statements? Specifically when I use it on a calculated culumn.
Building a status (project/risk) page and I use Probabiliy and Impact (1-3) to score the status/risk. No problem, then I use a calculated column to show images based on the value of the two combined(1-9 (green, Yellow, red).
If I point the calculated column to one of the values (Probability or Impact) I can get the image to change based on the value, but when I aim the column at the combined value it seems to not understand the value, all I get is a green light?!
The syntax seems to be right since i can get the result on the individual values, but not the combined...
Here is the formula i use in the caolculated culumn, by the way.
="<center>"& IF([Risk_value]<="4","<img src='/sites/111607/CDC_STHLM/SiteAssets/Status_pic/Green.gif' border='0'/>", IF([Risk_value]="6","<img src='/sites/111607/CDC_STHLM/SiteAssets/Status_pic/Orange.gif' border='0'/>", IF([Risk_value]>"6","<img src='/sites/111607/CDC_STHLM/SiteAssets/Status_pic/Red.gif' border='0'/>"))) &"</center>"