If you’re like me, you’re constantly finding new useful things in SharePoint that have been sitting right in front of you all along. I’m working with a smart guy named Bob Nash from CSC at a client right now, and he just showed me a cool thing you can do with a list column.
Say you want to track projects that your team is working on in a Custom List and capture activities which occur over the course of the project. Once you’ve got the list set up with the columns of information that you’d like to track, go to List Settings/General Settings/Versioning settings and turn versioning on.
Then create a new column (call it ‘Activity’, for example) and set it to be a ‘Multiple lines of text’. Because you have versioning turned on, you’ll see an option at the bottom of the column creation screen that allows you to ‘Append Changes to Existing Text’ — click the ‘Yes’ option and save your column.
Now, whenever anyone edits the item and types new activity information in the ‘Activity’ column, you’ll see the user’s name and a date/time stamp for their entry in the list of all previous entries. Nice!