IF(OR Statement giving #unparseable, using ; or , ?

Lisa Rogers
Lisa Rogers ✭✭
edited 06/03/20 in Formulas and Functions

Please help. I keep getting #unparseable error for the following formula:

=IF(OR([DLExpiration Date]1 > TODAY(); [MECExpiration Date]1 > TODAY()); "NON COMPLIANT"; "COMPLIANT")

I want the cell in my Status column to display as NON COMPLIANT or COMPLIANT if today's date is greater than the dates in columns DLExpiration Date or MECExpirtion Date.

Best Answer


  • Genevieve P.
    Genevieve P. Employee Admin

    Hi Lisa,

    I see that my response answered your question, which is great! I hope you don't mind but I've adjusted the title of your question to help other users who may have the same question find the answer.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!