Skip to main content
Question

text OR date in same field

  • May 16, 2017
  • 0 replies
  • 118 views

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.

      This topic has been closed for replies.

      • EricJHansen
      • Registered
      • May 18, 2017
      You can create a formula text field that will display the date or text, and then in your timeline report, add that as one of the columns to the left of the timeline section. You would still need to use a read date field to create the start or end of the timeline.
      Terms & ConditionsAccessibility statement