Formula needed to show a URL link from another field

[todcrowe]

I am attempting to have a field that will either show that a task is Scheduled or display a [Mark as Scheduled] URL Hyperlink.  I have fields for Scheduled (checkbox) and custom URL field.

[Stephen_Orr1]

IF({Scheduled}, 'Scheduled', {URL field})

Note: this will display the URL, not a "Mark as Scheduled" hyperlink as formula fields cannot output rich text.