IF/THEN/Else with Dates
I'm needing to create a column date formula for if appointment type = a or b, then Report Due Date = Appt Date + 60; and if Appointment Type = anything else, then report due date = appt date + 30.
Based on answers to other similar questions, here is what I have so far: =IF(APPOINTMENT_TYPE@ROW="SIBTF_-_INITIAL", [APPT_DATE]@ROW +60, IF(APPOINTMENT_TYPE@ROW=****This is where I am stuck because I do not know how to make this read "if appointment type is anything else. However, it does not work even if I stop before the second "IF", so I must have something fundamentally wrong.
Any help is greatly appreciated!
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!