Is there a Sharepoint Expert that can help me on this one.
I want to insert traffic lights if certain criterea is met. I have achieved this using single criterea where I set up a column called RAG and a column call Traffic Light, and depending what was in that cell RAG, i.e. R, A or G the Traffic Light will insert the appropriate 'picture' being Red Amber or Green.
What I am now trying to do is include a third dimention but cannot get this to work.
So. my query is ,IF(OR([Status]="WIP",[Sta
tus]="Yet to Start",IF([Target Date]<=TODAY(),"<IMG src='http://xxx/yyy/AS/Pictures/_t/kpiryg-2_gif.jpg'
Much appreciate your assistance with this.