My formula IF(AND((K4,"Non-Discretionary,M2<44926,"Priority 1",IF(AND((K4,"Discretionary,L4,Discretionary","Priority 3","Not Prioritized")
is returning #VALUE
What I want the formula to do: if k4 = non-discretionary and M2 is less than 12/31/2022, put Priority 1, if K4=discretionary and L4 = discretionary, put Priority 3, and if none of those are true, put "Not Prioritized
for the date column (M), it is formatted as a date, so I wasn't sure i i put in the actual date or the value in the formula.
is returning #VALUE
What I want the formula to do: if k4 = non-discretionary and M2 is less than 12/31/2022, put Priority 1, if K4=discretionary and L4 = discretionary, put Priority 3, and if none of those are true, put "Not Prioritized
for the date column (M), it is formatted as a date, so I wasn't sure i i put in the actual date or the value in the formula.