I've got a large list of documents that undergo regular maintenance.ÃÂ To help facilitate this, we had an Excel spreadsheet (recently converted into a Custom List in SharePoint) containing columns with "Date Last Revised"(Date), "Effective Period"(number), "Delay"(number), and "Next Revision Start Date"(calculated; Date Last Revised + Effective Period + Delay).
This works fine, until you get into SharePoint.ÃÂ My columns are:
ÃÂ ÃÂ Date Last Revised - Date and Time (Date Only) format
ÃÂ ÃÂ Effective Period - Number format, Default Value = 365 (1 year)
ÃÂ ÃÂ Delay - Number format, Default Value = 0
ÃÂ ÃÂ Next Revision Start Date - Calculated (based on other columns) format; sum of other three columns
The Calculated column works fine, and will calculate a Date based on the values of the other columns.ÃÂ HOWEVER, my ultimate goal would be to have a Calendar View of this information, where the Start/End dates are the "Next Revision Start Date" column.
When I try to use any other Date column, it works.ÃÂ When I try to use the calculated "date" column, it gives me a generic error message:
An unexpected error has occurred.
I don't really want to lose the functionality of each item being able to have separate effective period and delay values, but any informatio
View Complete Post