I want to apply a formula in the custom field to show indicators depending on my current status:
1. Current date is between my planned start and finish date or when actuals are present then actual start date and finish date
When % complete = 0 ( show as Red color)
When % complete < 100 ( show as amber )