Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
Calculated field with a list column and a site column added to the list

問題 Calculated field with a list column and a site column added to the list

  • 2008年7月30日 11:18
     
     
    登入以投票
    0

     

    Hi,

    I am trying to add a column to a list based on concating 2 other columns of the same list, of which the first column is location , single line of text and the other is a site column added to the list called country.

    formula i have tried =[country]&[location]

    error:

    One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas.   at Microsoft.SharePoint.Library.SPRequestInternalClass.AddField(String bstrUrl, String bstrListName, String bstrSchemaXml, Int32 grfAdd)
       at Microsoft.SharePoint.Library.SPRequest.AddField(String bstrUrl, String bstrListName, String bstrSchemaXml, Int32 grfAdd)
    Troubleshoot issues with Windows SharePoint Services.
     

所有回覆

  • 2008年8月11日 3:09
     
     
    登入以投票
    0

    Hi Chanil,

     

    I can create a calculated column concat-ing two single-line text columns by using a formula like this:

    =CONCATENATE([Country],[Location])

     

    Regards,

    Colt