Color Date Field

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress

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?


Photo of J1987

J1987

  • 60 Points

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
short answer:
Exactly the way you described, No.

Long Answer:
If you want to add some color and have reporting and flexibility of the milestones I'd recommend making those "milestones" into a child table.

Then you can color the rows based on any criteria, and it make it much easier in the future if you add or remove a milestone from your workflow.
It also makes management of those dates simple without having to rely on 22 different fields (and form rules to boot)