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.
Removing full stops from a number sequence
Hi all, We have a single line text column that we use to ID folders. The ID's follow this structure 1.1.2.1.2 Is there a way a calculated field can take this sequence and remove the full stops between the numbers so instead of 1.1.2.1.2 we get a calculated column that returns 11212? Thanks!