Create a calculated column which will display a combination of values from multiple different rows

Question

I'm trying to create a calculated column which will display a combination of values from multiple different rows. In my example list below, look at the "Dependencies" column for User "George". I would like to display the status of multiple users duties in this column.&nbsp;Hopefully this can be done without creating a second list?&nbsp;&nbsp;In my real list, there are over 1,000 items and the dependencies are not in order.&nbsp;User&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Job&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Duty Status&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DependenciesHank&nbsp; &nbsp; &nbsp; &nbsp; Buy Supplies&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Done&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NoneJudy&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Bake Cake&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Done&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Hank Bought Supplies&nbsp; : DoneBrent&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Package Cake&nbsp; &nbsp; &nbsp; &nbsp;Not Done&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Judy Baked Cake&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;: DoneGeorge&nbsp; &nbsp; &nbsp; &nbsp;Send Cake&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Not Done&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Hank Bought Supplies&nbsp; : Done&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Judy Baked Cake&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; : Done&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Brent&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; : Not Done

robelliott · Answer

barlage&nbsp;that's not possible because list items can't refer to other items in the same list.&nbsp;RobLos GallardosIntranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

barlage · Answer

Thanks for your reply, but I cannot mark "it isn't possible" as an accepted solution.Can you offer any advice on how you would handle this scenario?

Forum Discussion

Create a calculated column which will display a combination of values from multiple different rows

2 Replies

Resources