http://www.endusersharepoint.com/STP/ Paul Grenier, Lead Moderator en Tue, 10 Feb 2009 11:00:24 +0000 http://www.endusersharepoint.com/STP/topic/creating-a-calculated-column-based-off-a-differnt-date-column#post-4033 Sat, 07 Feb 2009 12:59:52 +0000 jaylou 4033@http://www.endusersharepoint.com/STP/ <p>Thank you Toni, I will let you know how it works out :)</p> <p>Joe </p> http://www.endusersharepoint.com/STP/topic/creating-a-calculated-column-based-off-a-differnt-date-column#post-4032 Sat, 07 Feb 2009 12:27:11 +0000 Toni 4032@http://www.endusersharepoint.com/STP/ <p>Maybe this might help: <a href="http://www.endusersharepoint.com/?p=1069" rel="nofollow">http://www.endusersharepoint.com/?p=1069</a> </p> http://www.endusersharepoint.com/STP/topic/creating-a-calculated-column-based-off-a-differnt-date-column#post-4031 Sat, 07 Feb 2009 11:17:54 +0000 jaylou 4031@http://www.endusersharepoint.com/STP/ <p>Thank you for the response.</p> <p>Would the 2 web parts be able to be displayed on the row in my list? </p> <p>We have a form where different business units will fill out IT requests. There is a workflow associated with it where we assign the request to a member of our IT department depending on the type of request. There is a due date from the requestor, when it gets assigned, the IT member will place a true due date in another column in the list.<br /> I have created an SSRS report off of the UserData table in my content DB, that shows all requests where due date is less then today (getdate()), and the True due date is also less then today. This works well, but for some reason the tp_Author and the tp_Editor are not always accurate. I am sure there is another table linking the correct users but I haven’t found it yet. (I have been looking thru all the userdata tables). This is not a big deal; since we look up the late requests and notify the person they are late.</p> <p>After the NYC SPUG meeting, I thought it would be great to be able to have a red, yellow and green dot/line showing the status right in the list.</p> <p>Thanks again,<br /> Joe </p> http://www.endusersharepoint.com/STP/topic/creating-a-calculated-column-based-off-a-differnt-date-column#post-4026 Fri, 06 Feb 2009 19:26:40 +0000 AutoSponge 4026@http://www.endusersharepoint.com/STP/ <p>Welcome to the most common complaint in calculated columns. There are hacks and workarounds but to get the expected solution you need either a custom web part or custom programming.</p> <p>If you're just getting your feet wet, I suggest you have two List View Web Parts, one called "Good" and one called "Bad". Filter them based on greater than or less than [Today].</p> <p>Christophe and I have posted some javascript solutions but it helps to have actual requirements before we suggest a "solution" since they are often not things you can adjust on your own without some practice with scripting. </p> http://www.endusersharepoint.com/STP/topic/creating-a-calculated-column-based-off-a-differnt-date-column#post-4012 Fri, 06 Feb 2009 14:11:03 +0000 jaylou 4012@http://www.endusersharepoint.com/STP/ <p>Hi,<br /> I attended the last NYC SPUG meeting this past Wednesday and saw alot of cool dashboard features I can use out of the box. Now that I am trying to do a similar column in one of my lists I can't figure it out.</p> <p>I have a list where I have projects and due dates. I would like to create a new calculated column based off the Due Date column. I created the new column and in the formula I entered<br /> =IF([Due Date]&lt;today,"Good","Bad"). (just as a test to see if it works)</p> <p>I am getting a syntax error "Calculated columns cannot contain volatile functions like Today and Me." </p> <p>Is it possible to create a column that will look at due date and if its greater then "today" make the text red and late if not green? Or something to that effect.</p> <p>TIA,<br /> Joe </p>