Paul Galvin's (old) SharePoint space [SharePoint

Just another site

Using “Person or Group” in a calculated column

People commonly ask about using a column of data type "Person or Group" in another column of data type "Calculated".

Bottom line, this does not work in WSS 3.0 (or MOSS).

When adding a calculated column, WSS shows the list of fields it allows you to use for the calculation.  If you type in the name of a column that is not in its list, it tells you:

One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas.

Workaround: Use an event handler.  The event handler fires when the user saves the item.  It performs the update you would have wanted the calculated column to do for you.

Useful links on calculated fields in general:

Quick disclaimer: I believe the above to be true and accurate, but I’ve seen enough clever tricks here and there in MOSS/WSS that I wouldn’t be extremely surprised (agog if you will) if someone has figured out a way to do this without resorting to code.  If you’ve figured out clever work-around or know someone that did, please let me know!


5 responses to “Using “Person or Group” in a calculated column

  1. Vince October 26, 2007 at 2:53 pm

    So how do we use an event handler?

  2. Abhilash May 15, 2008 at 10:07 am

    Please let me know if you have got any workaround for Using "Person or Group" in a calculated column without using code..

  3. JD January 15, 2009 at 4:36 pm

    This is quite surprising — being able to count or manipulate person information in a calculated column would be quite useful, and it\’s disappoint to see a suggested work around being the deployment of custom code. I hope this is changed in the next version of Sharepoint.Thanks for the information, Paul!

  4. ?? July 17, 2009 at 12:39 am

    What about using workflow with sharepoint designer? I could put person or column of data type "Person of Group" in a column with workflow. If you want to get more information about this, please send me an email. 🙂

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: