One date time column: Target date
Requirement: Need to set default 'Target date',5 Days ahead of item creation date.
I have tried this:= but it is not working
=[Target date] = [Created] + 5
Kindly suggest some input for the same :)
This is working for me(Given that calculated column is of type DateOnly)
=DATE(YEAR(Created),MONTH(Created),DAY(Created)+5)
Refer this MSDN Documentation for more formulas
You cannot refer to the default value with calculated value. Refer the answer in MSDN link. A workaround for this to either use SharePoint designer workflow on Item Added, or you can go for the calculated column.
Hope this helps you.
The error “The formula contains reference(s) to field(s).” is by design. The default value cannot refer to other fields. This is because that the item hasn’t been created, the Created column value is none. You can’t set null to the “Target date” column default value.
As a workaround, you can create a calculated column, which is set as DATE(YEAR(Created),MONTH(Created),DAY(Created)+5). Then create a workflow, copy calculated column value to Target date column. Note: you need to set the workflow to be triggered when a new item is created and add pause action in the first step.