Linking subsets to a new list


If i have created 5 subsets from a long list and a new list (Subset 1 to 5). Is there a way i can set the formula in my properties of my longlist to command that all items included in the subset 1 shall be tagged as part of the new list for Subset 1 instead of doing it manually? Thanks in advance! Appreciate your help! 🙂


Best Answer


  • Hi @elaine.novel 


    I don't think you can do this by formula (unless proven otherwise).

    But this can be updated via an import process.

    If you create saved views of all the subsets with a boolean line item which you can use a formula of TRUE via boolean format. Then you can create an action to import these views into the new subset list property. This will update subset items. 

    I hope this helps and if you have any questions please do let me know.





  • Hi @usman.zia 


    Appreciate your response. The import cannot be an option. I will need to tag the subset to the new list because the dropdown will be the new list. I tried to create a property though in the long list but I was thinking if there is a better way to do it.  🙂

  • Hi Elaine,


    I'm still confused with your requirements.


    What do you mean by tagging? Can you create an example of what list 1 and list 2 are? What are the name of the subsets, and what business problems you're trying to solve?




  • Hi @LipChean_Soh 


    The requirement is this: i will have to create random subsets in let's say "the long list". Let's say 5 subsets.


    Then i will have to create a new list, which will serve as the dropdown in my adjustment module. The new list will contain SS1, SS2, SS3, SS4 and SS5. I need to create a new list because in my adjustment, i will need to select from the new list.


    However, the new list should to connected to the 5 random subsets that i first selected from the "long list". Just so when i select SS1, my adjustments will allocate to the first subset, if SS2, to the 2nd subset and so on. 


    Appreciate your assistance.


    Thanks again,


  • Thanks David, appreciate this! 🙂