SharePoint Online Modern Page Calculated Choice Column in Document Library
Hello, we would like to create calculation that can offer different choices based on another column value. Example: We have a choice column called “Object” and the user can able to select the following values: Books Gadgets Furniture Then we have a calculated choice column called “Object Type” that should offer options based on the selection value in “Object” column. If “Object” = ‘Books’ then, "Object Type" choice options needs to be: Fiction Non-Fiction Educational Children's Books If “Object” = ‘Gadgets’ then, "Object Type" options needs to be: Cellphone Game Console Cameras MP3s/MP4s Would this be possible to do? We tried adding a choice column in a Document Library but we weren't able to click the selection unless we enter Quick Edit mode.