Sorting on a metadata column

Looks like you can't create a calculated column from a multiple lines of text field. If this column needs to remain multiple lines of text, I would recommend that you add a new column to enter the date that you are currently embedding in the Multiple Lines of Text field. However, if you can switch the column to be a single line of text field, you can use the following formula in your new Calculated column. Create a new column called Update Date or something like that and for the formula, type =LEFT([Column Name],10). You can actually make this a Date column by selecting Date as the type of column to be returned. Then, you will be able to sort Newest to Oldest (or vice versa) on your new Update Date column. You can continue to use the same format for entering your text and the data will be extracted into the new column. This is not going to work if you need to retain more than 255 characters in that text column, however. If what you are trying to sort on is when the row got updated last, just sort on Modified Date. You may also be able to create a flow to extract the first 10 characters and add it to a new column as well and keep the column multiple lines of text. I'm trying to answer your specific question but honestly, there may be a totally different and more effective way to accomplish your outcome goal. You may want to consider a PowerApp.