I'm trying to create an extra column in my Project which tracks Finish dates and provides a RAG status as per that date.
- If my Task Finish date is today or earlier, then show that task(?) (or the cell in my new column?) as red
- If my Task Finish date is within the next 3 days, then show it as yellow
- If my Task Finish date is more than 3 days away then show it as green (or leave blank - TBC!!)
I've looked at Status Indicator but I'm getting stuck with trying the write a formula that will make it work, but it might not be what I'm looking for - or there is a better way.
Any help or advice is greatly appreciated.