Sharepoint column not appearing when creating calculated column

[SmithyJD]

I have created a new list to manage reoocuring calendar task to get round the issue of not displaying sub headings for all day tasks I want to create a calculated field combining Task and closed by. However the closed by column doesnt appear in the list when i try and add a calculted field, any ideas why ?

Thanks in hope

John

 

[ehaze]

this will explain it:

http://blog.kiwibees.net/?p=85

SharePoint can only perform a lookup of values from columns that contain a ‘text’ value, and then only if it contains a single line of normal text (ie. “Single line of text”, a “number”, or “date”). Any field that contains multiple lines of text, other lookups, or multi-select items won’t be available to you, as SharePoint will automatically hide any columns that it knows it can’t return.

http://www.sharepointed.com/

 

[SmithyJD]

That explains it then its a Lookup field I am trying to combine, back to the drawing board for that then.

Thanks

Jd

 

[ehaze]

try cracking open SharePoint Designer and work with the Data View web part.

http://www.learningsharepoint.com/2010/10/16/create-dataview-webpart-in-sharepoint-2010-tutorial/

Display data from multiple sources in a single Data View
Applies to: Microsoft Office SharePoint Designer 2007

http://office.microsoft.com/en-us/s...ources-in-a-single-data-view-HA010099144.aspx

http://www.sharepointed.com/