Hi, I have a list of many-to-many items, Site Hazards. A Site can have many Hazards and a Hazard can be found in many Sites.
When I list the Site Hazards, by selecting a Site, I would like to set the Display Name of the list to the [Name] for the Site.
eg. CONCATENATE("Hazards for ", [Name])
I note that at the top of the screen is a message:
"This formula is not evaluated in the context of a row, so column values are not available."
This makes sense, however is there a way I can either pass through the Site Name from the selected Site. Or maybe take the first row from the slice and get the Name for the Site?
LinkedIn
Twitter
