Search code examples
sharepointsharepoint-2010sharepoint-2007sharepoint-2013

Error in Calculated Column (using Today) in DataSheet View - Sharepoint 2010

I have calulated column which display's the value based on the difference between today and requested date field.

=Today-[Requested Date]

This is working fine in Sharepoint Standard View. But the same is not working with the datasheet view . The calculated column is showing as below

=#NAME?-[Requested Date].

Due to this i am not able to save the data. Can anyone please let me know how to solve this ?

Solution

  • Which SharePoint version are you using?

    I tried the same scenario using SharePoint 2013 and was able to add the values in both standard and datasheet views. I am assuming you might have used the same steps.

    • Create 2 new columns named RequestedDate(DateTime) and Today(Single line of text).
    • Add a new column of type calculated field with formula =Today-[Requested Date].
    • Now delete the Today column.
    • Try entering the data in both the views.