Hi!
In my first sheet, I have a column "Date Submitted to Courseware". Then, someone selects an "Analysis Priority".
First sheet
The Analysis Priority should look up the References sheet to the columns for AnalysisPriorityTypeDropDown, match that, and figure in the AnalysisPriorityTypeValue number of days, and figure in holidays and based off the Date Submitted to Courseware (from the first sheet), will give me the Analysis Due Date.
References sheet
I've tried this:
=WORKDAY([Date Submitted to Courseware]@row , INDEX({References}, MATCH([Analysis Priority]@row , {AnalysisPriorityTypeDropDown:AnalysisPriorityTypeDropDown}, 0)), {Holidays Column})
and this:
=WORKDAY([Pre-Analysis Completed]@row , INDEX({AnalysisPriorityTypeValue}, MATCH([Analysis Priority]@row , {AnalysisPriorityTypeDropDown}, 0)), {Holidays})
This second formula I got invalid data type.
Thank you, in advance, for your help!
Chelsea
