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

I suggest using color-coding on the report using a formula.

This would be your formula:

If(not isnull([Appointment Scheduled]),"green",
[Appointment Needed By]<Today() and isnull([Appointment Scheduled]),"red",
[Appointment Needed By]<=(Today()+days(7)) and isnull([Appointment Scheduled]),"yellow")

Check out this video for an example: https://www.quickbasejunkie.com/blog/how-to-color-code-rows

And if you want to highlight the fields themselves, you will need to either create additional fields or add them as report fields.

Here is a video for an example of that: https://www.quickbasejunkie.com/blog/how-to-add-text-color

Let me know how it works out! 👍

------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------