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

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #417222 Reply
    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 Reply
    Larry ChristofaroLarry 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 2 posts - 1 through 2 (of 2 total)
Reply To: Microsoft Project 16 -populating custom field with Month of Task Start Date
Your information:




+ 28 = 31