Potential for nested grouping in vLookup

Home Forums Modern DFFS Potential for nested grouping in vLookup

Viewing 1 reply thread
  • Author
    Posts
    • #38431
      Travis Goodman
      Participant

        Hey Alex, so I have an idea for you, want to get your thoughts on it. I have a situation where I’m making a Project Management tool out of SharePoint lists.

        List 1: Primary Project Management List (the master/parent)
        List 2: Milestones list that items are created via vLookup “add new item” button, and a lookup column on List 2 is set so that the item gets legitimately linked to List 1. The ID# from List 1 will be entered into this lookup field on List 2. I also set the Parent/Child DFFSIDs accordingly.
        List 3: Tasks for each Milestone from List 2 are created here via the “add new item” button. I have another lookup column here that points back to List 1 and I’m carrying the value over from List 2. That means even List 3 can be linked directly to List 1.

        Anyway, right now I have to set this up so that they appear in 2 separate tables (see screenshot) but it’d be awesome if I could set it up so that it all appears in just one table. You could edit the Milestone or the Task from within this one table.

        Let me know your thoughts, maybe I’m not even setting this up in the best way.

      • #38433
        Travis Goodman
        Participant

          When i edit a milestone, that’s where I can add new tasks (see screenshot in this message). That’s what creates the Tasks that appear in the bottom of the first screenshot that are associated to the milestone.

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