Microsoft Project 16 -populating custom field with Month of Task Start Date

Home Forums Discussion Forum Microsoft Project 16 -populating custom field with Month of Task Start Date

Viewing 1 reply thread
  • Author
    Posts
    • #417222
      Phyllis Clark
      Guest

      I am trying to populate a custom field (number1 field called TMON) with the month of task start date. I used a formula below:

      TMON= Month(Start)

      I want to group on TMON so that tasks with start dates during the same month will be grouped together. I entered values for TMON in the lookup table such that 1 is Jan, 2 is Feb, etc.

      What am I missing?

    • #417225
      Larry Christofaro
      Participant

      Hi Phyllis. I’m not sure what you are trying to do but you can’t define a custom field as both a looking table and a formula. Try this. Create a new Group (View, Group, New Group by) . Enter Start as the Field Name, and then go to the “Define Group Intervals button under the Group by settings. Their you can set Group On to Months and the Start at to the first of the month. I think that should get you what you are looking for…??
      Hope that helps.

Viewing 1 reply thread
  • You must be logged in to reply to this topic.