Workload Widget won't recognized a Date formula field as valid workload

On our individual project boards we use a calculated due date so that each phase of the project can be done in time to meet the overall CRM Due date. This date is based on the Name of the pulse. We need the Widget to allow us to choose this date to determine workload due for a particular week.

FORMAT_DATE(FORMAT_DATE(
IF(Left({Name},10)=“NEW-Resear”,FORMAT_DATE(SUBTRACT_DAYS({CRM Due Date}, 48)),
IF(Left({Name},10)=“NEW-Establ”,FORMAT_DATE(SUBTRACT_DAYS({CRM Due Date}, 48)),
IF(Left({Name},15)=“NEW-Blueprint D”,FORMAT_DATE(SUBTRACT_DAYS({CRM Due Date}, 7)),
IF(Left({Name},15)=“NEW-Blueprint C”,FORMAT_DATE(SUBTRACT_DAYS({CRM Due Date}, 7)),
IF(Left({Name},20)=“NEW-Blueprint review”,FORMAT_DATE(SUBTRACT_DAYS({CRM Due Date}, 3)),
IF(Left({Name},14)=“NEW-Escalation”,{CRM Due Date},
IF(Left({Name},10)=“NEW-Beta T”,FORMAT_DATE(ADD_DAYS({CRM Due Date}, 84)),
IF(Left({Name},10)=“NEW-Update”,FORMAT_DATE(ADD_DAYS({CRM Due Date}, 84))
,TODAY()
, “MM-DD-YYYY”))))))))),“MM-DD-YYYY”)