I have a task to create a Document Library in Sharepoint. I have done this several times. This particular site have a bit of a complex index structure. I am stuck on figuring out if it is even possible to do. I have one column (called Folder type) that is set up as a choice with several index option. I need to create another column (called Assigned) that is calculated display a choice of options based on folder type. So for example:
If in "Folder Type" the user chooses "Administrator" Then the column Assigned should provide a choice list of assigned choices. In this case a list of administrators to choose from. If they chose Jurisdiction they will see a list of the available jurisdictions to choose from.
I cant seem to get the formula right. Please help, otherwise I am forced to create individual columns for each Folder type, which can get messy.