Hey guys,
im slowly loosing my nerves with this one. I have a form where i need to gather various values from different lists and i have to use calculated formulas with lookups in them.
The list is a collection of information from different companies. There is always the folder named like the company number and inside of the folder there are the items i want to have the values from. The problem is that i do not get any values when i lookup for items inside of the folders. When I lookup the folders themselves (filtered by the ID or the folder name) i get the item.,
Did anybody else face this issue and found out how to resolve it?
Greetings from Germany
--- Example
lookup("Listname", "Id", #FolderID, "Title") WORKS
lookup("Listname", "Id", #IDfromItemInsideFolder, "Title") Not working