Show the most recent comment from SharePoint text fields instead of “view items”

Show the most recent comment from SharePoint text fields instead of “view items”

SharePoint
[wp_ad_camp_1] [wp_ad_camp_4] How to show the most recent comment instead of ‘view items’ in SharePoint lists When you set up a SharePoint list you can create a text column that keeps a history of previous entries. You enable this by selecting Yes for the Append Changes to Existing Text column setting. This is handy for a comments field where you need to keep track of user comment history, for example. The problem I’ve had is that when you put this column in a SharePoint view you wind up seeing a hyperlink with the text “view items”. This is not helpful. Further, the link always shows up – even when there are no comments or text in the column. This just makes for way too much clicking back and forth. The…
Read More

Print Column Headings on Every Page in Excel

100 level, Excel
Print column headings on every page in Excel so that every page printed has the labels at the top of the columns. This will save a bunch of flipping back and forth to keep track of what you are reading on subsequent pages. The few steps below are specifically for Excel 2010, but they’ll general apply to your version of Excel too. The key is to get to the Page Setup dialog box where you will specify which row contains your column headings. How to print column headings on every page in Excel 2010 In Excel 2010, go to the Page Layout tab and click Print Titles. This is in the Page Setup group on the ribbon. Go to the Sheet tab on the Page Setup dialog box. Here, you…
Read More
TFS Daily Emails

TFS Daily Emails

PowerShell
[wp_ad_camp_1] [wp_ad_camp_4] TFS Daily Emails: How to get regular TFS query results into your inbox automatically Team Foundation Server (TFS) allows you to create queries and save them as personal views or team views. You can even set up alerts on individual work items assigned to you so you know when they’re created or changed. However, TFS doesn’t give you a way to get a recurring snapshot of the TFS view you created into your inbox automatically. Sometimes waiting for a change event isn't what you're looking for. I’ve used the process outlined below for TFS daily emails and it’s been working great for me. I’m using a combination of the following: PowerShellTFS 2010Outlook 2010Task Scheduler You may not have the exact same versions as I’m working with, but the…
Read More
Display icons in SharePoint lists

Display icons in SharePoint lists

SharePoint
[wp_ad_camp_1] [wp_ad_camp_4] How to display status icons in a SharePoint list I needed to display a KPI indicator icon in one of my SharePoint list columns. To display status icons in SharePoint lists in my case, I needed to show a Red/Yellow/Green status symbol. I couldn’t find a setting in SharePoint that made this easy as I had done in Excel and Project before. But then a colleague showed me a little trick that scratched the itch just fine. The setup You’ll need to have a field that carries a value that the user can set. In my case, I created a field called “Status” and made it a drop-down select list with the values “Red”, “Yellow”, and “Green”. Next, I created a calculated field I called “Status Indicator”. The…
Read More