I have several records/projects which all have the same milestones. I have created 11 DATE fields to represent the 11 milestones. I have also created 11 CHECKBOX fields to indicate a particular milestone is complete.
What I want: Each milestone for each project will have a predetermined date. When a milestone completes, I do not want to overwrite the predetermined date. Instead, I want to color the field to indicate it is complete, and still have the predetermined date visible. Which is why I created the Checkbox fields, thinking I could do a formula where IF Checkbox Field Yes, then Color DATE field Grey. (The checkbox fields will be on 1 report, and the date fields on another report)
Can I make this work?