Hyperlink Mailto with If and OR and Today() Functions

[evgarcia29]

Hi Everyone!

I know I'm close but I've hit a brick wall. I have a form where users fill it out and submit via email. There is a Hyperlink Mailto cell (O12:V15) that I want them to click and it generate an email with proper subject depending on cells within the form. Here's what I have already:

=IF(OR(I8="Equipment Revision", I8="Dates Revision", I8= "Equipment & Dates Revision", I8= "Cancellation Revision"),HYPERLINK("mailto:"&Q11&"?subject="&TEXT(C9,"mm/dd")&" - "&TEXT(C12,"mm/dd")&" | Revised Equipment Request | "&K7&" | "&I6&"&body="&P17,"CLICK HERE TO GENERATE EQUIPMENT REQUEST EMAIL"),HYPERLINK("mailto:"&Q11&"?subject="&TEXT(C9,"mm/dd")&" - "&TEXT(C12,"mm/dd")&" | Equipment Request | "&K7&" | "&I6&"&body="&P17,"CLICK HERE TO GENERATE EQUIPMENT REQUEST EMAIL"))

I want to add the ability to change the Subject to read: "Pop Up Equipment Request" if the delivery date (C9) equals the date of submission.

I think the TODAY() is throwing me off. Any help is much appreciated!