May 2004 - Posts

• Would like to see tutorial on how to add graphs to some list data

  You know how when you create an Issues list, it automatically gives you a link called “View Reports” under actions?  And the links under there give some pretty neat graphs?  Well, I'd like to make some of those, and I'd like to see a how-to or step-by-step on it. Say I've created a list that has category, work minutes to complete, severity, person (from A/D) etc (much like the issues) and I want to graph, these entries based on count, time, etc per category, person, etc. Assume I have Frontpage, Access, Visual Studio .NET, MSDN.  Know of a tutorial for me?   Posted May 26 2004, 04:39 PM by Unclaimed Blog with no comments

• Freeze column or pane like in Excel -- available in Datasheet view?

  I've had some users ask about whether or not they could get the “freeze pane” or “freeze column” type of functionality when editing in datasheet view.  I've not seen it, and have recommended thus far that they use the Task pane, edit and link in Excel, and save off their excel spreadsheet when updating the data. Anyone have an answer for this?  Posted May 13 2004, 02:24 PM by Unclaimed Blog with no comments

• Impressed with a small list feature when renaming columns in a list...

  So I renamed one of the columns in a list, and I had already created a calculated column that referenced that column.  It changed the formula for me!  Yes, it's the little things that can impress me.  I'm glad they got it right. Posted May 07 2004, 07:38 AM by Unclaimed Blog with no comments

• Wish I could display "totals" for a calculated field in a view...

  So I have this “work blog” that I created for my team.  It's meant to be very simple for all the admins to put in what they've done, from the menial (added user to distro list) to the major (implemented SMS 2.0).  It has “entry”, “details”, Category (radio buttons) and importance (low/med/high).  It helps me do the weekly status reports. An optional field is “minutes“.  I also have a caculated field which is minutes/60 so I can see estimated work hours.  I also have three views -- one which is just “most recent first“, which functions like a normal blog, another view which is some details by employee, and another which is Work by category -- which would show about how much work hours done in the week, by category. Problem is -- I can't do a “total“ by this calculated field.  I can only do it if I also display the minutes, and then total them up.  But I don't want minutes displayed, I want work hours, and that's the whole reason I created the calculated field. Any workarounds? Here are some sample pics:     Posted May 06 2004, 09:14 PM by Unclaimed Blog with 2 comment(s)

• A fix for Annoying Date/Time fields in lists (Modified, Created, etc)

  If you're like me, you probably don't like the fact that sharepoint will automatically show the date and time like You should patch your system           Wayne Hall          05/04/2004 12:00:00am So, what you can do is create a new column with your list called “timestamp” that is a calculated formula with the following: =TEXT(WEEKDAY(Modified),"ddd")&" "&TEXT(Modified,"h:mm") That way it just prints “Tue 5:03”, which is a lot easier to read, especially when looking at, say a view that shows the most recent 5 documents added to a document library or something.   If I get time, maybe I'll figure out how to do something that analyzes it to say ... if it's < 7 days old, do the day and time, and if it's older, do MM/DD.  The problem I run into is that it won't let you do [today] or [me] in calculated columns.  Maybe I need to do that in xslt? IE, =IF([TODAY]-Modified<=7, TEXT(WEEKDAY(Modified),"ddd")&" "&TEXT(Modified,"h:mm"),TEXT(Modified,"mm/dd")) Posted May 05 2004, 02:33 AM by Unclaimed Blog with no comments