So you want your viewers to know the last time data was refreshed or updated in your SharePoint list without having the list’s default “modified” column repeating the same date hundreds of times and taking up horizontal space.
There are a number of solutions out there to show the date a list was last modified using code. This solution provides an option best used with lists you bulk update, or copy and paste to replace all data regularly, but requires no coding. It basically pulls out the “last modified” date of your first list item and displays it at the top as seen above. This solution is not for you if you are updating only specific items within a list.
- Edit page of the list you’re working with
- Add a web part
- Find the name of your list under the “apps” folder under categories. Select it.
- Click “Add”
- Edit web part
- Under “List Views” change “Toolbar Type” to “No Toolbar” & Under “Appearance” change “Chrome Type” to “None”
- Select “Apply”
- Under “List Views” select “edit the current view”
- Uncheck every box under “Columns” except for “Modified”
Note: Use “Created” instead if you have any workflows running that might change the date automatically such as a “today” column workaround. This is only helpful when you’re bulk-replacing (copying and pasting) data. - Expand “Style” and select “Basic Table”
- Expand the “item limit” section and change “number of items to display” to 1 and select the “limit the total number” radio button
- In the Mobile section, uncheck “enable this view for mobile access”
- Click OK
- That should give you something like this. If, for some reason, it adds additional columns, just “edit the current view” again and uncheck all but modified.