A JSON column can be used to store structured pairs of data (objects) and can be reference it using Formula column. You can directly store the json script in the cell and also validate your JSON files.

You can extract this value in a Formula column with formula as shown below

And below is the output of Formula column

The sort option can be used to sort the rows from first to last or last to first based on the value of this column. Read more about sort here.

Did this answer your question?