Ok, so I figured out how to add a row which shows the last modified date, excellent! However, when I upload new records into my list it shows the last modified date at the date I added the records. Any way to avoid the initial modified date and only show that date when the record gets modified?
1 Answer
The Modified column is built-in and you can't change it. But, you can create a new column to achieve your goal, like this:
- Create a Calculated column, named "My modified";
- Type this formula in the Formula box: =IF([Modified]=[Created],"",Modified)
- The data type is: Date and time; (you can shoose keep date only or with time)
- Remove the built-in Modified column from your default view, replace it with the new "My modified" column.