Stump the Panel » End Users and Information Workers

Creating a calculated column based off a differnt date column

(5 posts)

  1. jaylou
    Member

    Hi,
    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.

    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
    =IF([Due Date]<today,"Good","Bad"). (just as a test to see if it works)

    I am getting a syntax error "Calculated columns cannot contain volatile functions like Today and Me."

    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.

    TIA,
    Joe

    Posted 3 days ago #

  2. AutoSponge
    Administrator

    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.

    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].

    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.

    Posted 3 days ago #

  3. jaylou
    Member

    Thank you for the response.

    Would the 2 web parts be able to be displayed on the row in my list?

    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.
    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.

    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.

    Thanks again,
    Joe

    Posted 2 days ago #

  4. Toni
    Moderator

    Maybe this might help: http://www.endusersharepoint.com/?p=1069

    Posted 2 days ago #

  5. jaylou
    Member

    Thank you Toni, I will let you know how it works out :)

    Joe

    Posted 2 days ago #

RSS feed for this topic

Reply

You must log in to post.