ContributionsMost RecentMost LikesSolutionsColor Date Field 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? Re: text OR date in same fieldThanks. I was hoping to minimize the number of fields so I did not have a lot of columns on a report. But, I guess I can build a report for updating milestones to 'complete' using the checkbox fields, and then another report for publishing the timline using the formula text field. Thank you for your help! I appreciate it.Re: text OR date in same fieldcan you please help me with the formula text field. thxtext OR date in same field I have a master table that contains 'projects'. There are many 'tasks' that make up each 'project'...and those tasks vary from initiative to initiative. However, at a high level, each 'project' has the same milestones it progresses through at varying speed. I'm fine with how I'm handling project to tasks relationship...and I'm using a report link in the 'project' table to display the drill down of the 'tasks' when clicked. What I want to have is a report that lists each project as a record, and then each milestone as a column/field, and then be able to put in each field either the due date or something to indicate the milestone is complete...and then be able to build the data into a timeline/gantt chart.