I am having issues getting my form to display due to an issue with a calculated value formula to calculated the target completion date based on the Level selected and the Assign Date. The Assign Date is also calculated and populated with a workflow to enter the current date and the form is submitted.
I have tried a couple of different combinations, but I can't seem to get around the issue. Here is just the latest rendition of what I am trying to do.
If(equals(LevelHours,"Level 1 = 24 Hours"),formatDate(dateAddDays(Assign Date,1,"MM/dd/yyyy"),
If(equals(LevelHours,"Level II = 48 Hours"),formatDate(dateAddDays(Assign Date,2,"MM/dd/yyyy"),
If(equals(LevelHours,"Level III = 72 Hours"),formatDate(dateAddDays(Assign Date,3,"MM/dd/yyyy"),
"TBD")))
I would appreciate any assistance as to where I am going wrong with this formula.
Thank you!!
