IF/THEN/Else with Dates

KSellers
KSellers ✭✭
edited 11/06/23 in Formulas and Functions

Hi All!

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!

Kelly

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!