Forum Discussion

MeaganMcOlin's avatar
MeaganMcOlin
Qrew Trainee
3 years ago

I need a formula that will show if a task is complete, overdue, or upcoming

I have a table with 2 date fields. The first field is Appointment Needed By and the second field is Appointment Scheduled

I need a formula that will highlight the Appointment Needed By field green if an there is a date in the Appointment Scheduled field, yellow if no appointment is scheduled and the Appointment Needed By date is coming up within 7 days, and red if we are past the Appointment Needed By date and an appointment was not scheduled. 

I have an attachment if that helps!

Thank you!



------------------------------
Meagan McOlin
------------------------------

1 Reply