The formula for the Ampersand column is =FIND(“@”,[Email]). Open the list and click on “New.”. Add Columns To Separate Sections Using JSON Formatting. . git //clone (path to your repository)5. You can create a workflow or Microsoft flow/power automate to update the Email address field based on the Person or Group field. If you are not going to use those email address values later (you don't need to save emails in column) and you just want to show the email in SharePoint list view then you can also achieve it using JSON column formatting. 3. read the readme.md file to know the requirements for your column. SharePoint List Hyperlink Column Not Working In visual studio code, create a new file with the .json file extension. Sometimes, when you create a column, if the column name contains certain characters, it will be encoded. It doesn’t need to be the column you are formating. The below code does not insert the file number, rather it inserts the following as the subject of the email: [File:” + @currentField + “] What I would like to have as the subject is as follows: [File:***] where *** is the text from the column. Below is the json I used in my example. That’s all you have to do to get color coding for null/blank values. There are three different formatting options, you can see examples of them in the links below where I’ve extracted the open source published Github samples in an easy to view visual manner: Option 1 – Column Formatting – Examples. 1. In column and view formatting, you can refer to any field's metadata by specifying the internal name of the field surrounded by square brackets and preceded by a exclamation mark: [!InternalName]. You can use column formatting to customize how fields in SharePoint lists and libraries are displayed.