Adding number of days to Date - Formula Field
Hello: Your friendly yet persistent novice with another question: I am trying to add days to a date - formula field based on selection in a different field. Error Message: Formula syntax e...
Forum Discussion
The problem is that there was an extra comma at the end
if(
[Work Type]="RD-Reactive",([Date Complete WO Received]+Days(5)),
[Work Type]="PJ-Planned Job",([Date Complete WO Received]+Days(12)),
[Work Type]="RP-Reactive Project",([Date Complete WO Received]+Days(10))
)
but this also can be simplified to
Case([Work Type],
"RD-Reactive", [Date Complete WO Received]+Days(5),
"PJ-Planned Job", [Date Complete WO Received]+Days(12),
"RP-Reactive Project",[Date Complete WO Received]+Days(10))
if(
[Work Type]="RD-Reactive",([Date Complete WO Received]+Days(5)),
[Work Type]="PJ-Planned Job",([Date Complete WO Received]+Days(12)),
[Work Type]="RP-Reactive Project",([Date Complete WO Received]+Days(10))
)
but this also can be simplified to
Case([Work Type],
"RD-Reactive", [Date Complete WO Received]+Days(5),
"PJ-Planned Job", [Date Complete WO Received]+Days(12),
"RP-Reactive Project",[Date Complete WO Received]+Days(10))