I need help writing an IF statement for a SP calculated column. I have it working right now to display the green indicator, but need to add the clauses for it to display the yellow and red indicators as well.
The first section (green status) is what is working, the rest needs modification I know. Basically I want to add :
IF Colour="Red" then display "/_layouts/images/KPIDefault-2.GIF"
IF Colour="Yellow" then display "/_layouts/images/KPIDefault-1.GIF"
PLEASE help :)