I have two required field in a document library. I want to use some conditional formatting for them. For example, when I upload a new document, I want the first column to show with several choices. Depending on the choice the user makes, I want the second required column to come up where they can select a secondary option. Is this doable? Right now both required columns come up when the upload file is clicked.
You would still have to use 2 different columns (1 in each content type) to achieve that. Because the data lives in 2 columns, you wouldn’t be able to sort or group as as whole. Queries would require checking both columns.