Forum Discussion
kaiyos
Jul 28, 2022Copper Contributor
Converting a set of alphanumeric code into another set of code using a specific naming rule
Hi guys, I would like to ask if is there any way (or formula) for me to convert numbers and alphabets with a rule i established. For example, i set a=1b; b=3b; c=4b, and 0=9q;1=3q; 2=3qb Is ther...
- Jan 28, 2023
Hi Anthony-123
"Going to my document library and creating a new view that sorts by active column results in zero items. This is why I'm using the Highlighted Content web part. If the document library view were able to show all documents regardless of number of nested folders, this would be ideal."
If you want to display all files in a view of a documentlibrary regardless of folders, you need to edit the View
And scroll down to and expand "Folders" and check "Show all items without folders"
This results in a view that displays all files in the document library regardless of folders.
You can still sort and filter that view to your liking.
Best Regards,
Sven
Harun24HR
Jul 28, 2022Bronze Contributor
Below formula may work for you. Give a try on it.
=CONCAT(XLOOKUP(MID(A1,SEQUENCE(LEN(A1)),1),F1:F6&"",G1:G6))