AnsweredAssumed Answered

Calc Help

Question asked by Darren Nichols on Aug 15, 2017
Latest reply on Aug 15, 2017 by Darren Nichols

I'm trying to get my completed date field to update based on my plan review schedule.  This is what I have come up with but getting an error.  Any help is much appreciated.





IF(VALUEOF([Plan Review Schedule],"Quarterly"),DATEADD(DAY, 90, [Completed Date])
IF(VALUEOF([Plan Review Schedule],"Semi-annual"),DATEADD(DAY, 180, [Completed Date])
IF(VALUEOF([Plan Review Schedule],"Annual"),DATEADD(DAY, 365, [Completed Date])))))