Set up milestones for a timeline report

Prev Next

Most timelines include events that mark the close of a project phase. Project managers call these milestones. You can call attention to such events on your timeline report. When you indicate that a specific task is a milestone, Quickbase displays it with a special diamond-shaped graphic.

Milestones display as diamonds that appear at an event's ending date.

To set up milestones:

  1. Create a checkbox field.

    You'll use a checkbox field to mark a record as a milestone. Add a new field to the table containing the events for which you want to create a timeline, and make its field type Checkbox. Name it Milestone. If you are prompted to add the field to forms, select Yes.

  2. Identify the new checkbox field as your table's milestone field.

    Create or open a timeline report in the report builder. Within the Milestone dropdown, select your new Milestone field.

  3. Within any records that you want to show as milestones, turn on the Milestone checkbox.


FAQ

I want all tasks with no duration to show as milestones. How can I automate this?

You can set this up. Instead of creating a regular checkbox field, create a Formula - Checkbox field that can turn itself on if there's no duration. Within the report builder, select that field from the milestone dropdown. The formula you'd enter in the field's properties page would read something like: If([Duration]=0,true,false)

Should you implement this setup, remember that milestones are based on an event's ending date. So, in order for your milestone to show up, you must have a date in the field you specified as the ending date, even if you're automating milestones with a Formula - Checkbox field.