I am trying to use calculated columns to have a possibility of 3 status indicators come up based on another column that is called projectstartday which shows how many days are left until a project needs to begin. I have been able to get green and red indicators, but not yellow using the following formula I think just because I don't know how to format the formula to add the other condition ;
I know that img src='/_layouts/images/KPIDefault-1.GIF' returns yellow, but do not know how to get it in the formula. I want the calculated field to return the following;
Show red in the sharepoint list: if ProjectStartDate is Less than or equal to 30 Show Yellow: if ProjectStartDate is Greater than 30 but less than or equal to 90 Show Green: If ProjectStartDate is Greater than 90
I have been trying to figure this out for forever now and would appreciate any help anyone can give me!!!!!