Calculated
2 TopicsRemoving 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!2.3KViews0likes2CommentsSharePoint 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.6.2KViews0likes5Comments