I have a production schedule I use that has a start date column and an projected completion date coulumn that is autofilled with a workday formula.
The actual completed date is not always the projected date.
Is there a way that I can have the projected date be formulated in light gray and then override it with the actual completed date in black when its done?