BTMarketingOps✭✭✭✭

Thank you! Such a silly thing that I missed!

@David Tutwiler我不小心点击了on No for Did it answer the question. Is there any way for you to undo that?

@Paul Newcome @David Tutwiler Never mind, David's last comment did solve my issue! Thanks David!

@Paul Newcome Did I post what you were looking for?

Attached is a screen shot of the row that is giving me the incorrect result. The reason I have <> in front of Immunoassay is because it is actually Immunoassay (ELISA/Luminex) but the formula gets confused with the () in that so I used the carrots to mean contains Immunoassay. Hope that makes sense. Here is the for mula…

Yes, that worked and good to know! Thank you, thank you, thank you!!! You just saved me hours of headache!

That still didn't work. Do I need something on the first iF?: =IF([Publish Start Date]@row = "", "", IF(MONTH([Publish Start Date]@row) = 1, "Jan", IF(MONTH([Publish Start Date]@row) = 2, "Feb", IF(MONTH([Publish Start Date]@row) = 3, "Mar", IF(MONTH([Publish Start Date]@row) = 4, "Apr", IF(MONTH([Publish Start Date]@row)…

Thank you, that worked!

Yes! Thank you! I tried something like that but didn't have it just right. You just saved me hours of work. Much appreciated!