Apr 14 2011
I ran into this today and thought it might be something worth jotting down to save others the same pain. When you’re editing a list in Datasheet view in SharePoint 2010 and you’re working with a Calculated column, you can see the formula at the bottom of the view for the cell in which you …
Permanent link to this article: http://sympmarc.com/2011/04/14/sharepoint-2010-datasheet-view-bugaboo/
Dec 04 2009
Ever helpful @MSwannMSFT – Matt Swann at Microsoft (why aren’t there more like him?) – spotted a Twitter discussion between @jvossers, @willhlaw, and me (@sympmarc) yesterday, and in his usual tenacious style, promised an answer. This guy doesn’t just guess, he goes and tracks down the line of code or the actual developer and finds …
Permanent link to this article: http://sympmarc.com/2009/12/04/how-are-a-sharepoint-lists-calculated-columns-stored-and-rendered/
Jul 29 2009
I usually test my formulas in Excel. The syntax is the same; if it works in Excel, it’s going to work in SharePoint. (There may be exceptions to this, but I haven’t run into them.) Simply set up some cells with the values you need and then work out your formula. Once you’ve got it …
Permanent link to this article: http://sympmarc.com/2009/07/29/quick-tip-testing-sharepoint-calculated-column-formulas/
Aug 13 2008
I’ve seen lots of posts discussing this, but no workarounds. Here’s the situation: One list (List 1) contains a list of values that are calculated (say ColumnC = ColumnA & ColumnB) Another list (List 2) uses ColumnC above as a lookup for one of its columns If you go into Datasheet view for List 2, …
Permanent link to this article: http://sympmarc.com/2008/08/13/string-before-values-in-a-sharepoint-lists-lookup-column-based-on-a-calculated-value/
Jan 29 2008
I’ve frequently been asked if it is possible to display only the current month’s documents in a SharePoint list. There is no obvious way to do this, as the filtering mechanism in a view will not allow you to specify a formula as its criteria. The trick is to create a calculated column on the …
Permanent link to this article: http://sympmarc.com/2008/01/29/showing-this-months-documents-in-a-sharepoint-list/
