none
Calculated field with a list column and a site column added to the list RRS feed

  • 問題

  •  

    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年7月30日 上午 11:18

所有回覆

  • 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

    2008年8月11日 上午 03:09