Incorrect Argument on IF/ISBLANK

VioletB ✭✭
edited 12/09/19 in Smartsheet Basics


I am trying to set up a  cell that automatically set a word in a cell depending on what the due date is.

If date is less than today's date "overdue" will be added to cell, If date is more that today's date "on track will be added, If there is no date, I would like the word "on hold" to be added. Not sure were I am going wrong.

thank you


=IF(OR(ISBLANK([Next Audit Due Date]6, "On Hold",””), IF([Next Audit Due Date]6 < TODAY(), "Overdue", IF([Next Audit Due Date]6 > TODAY(), "On Track")))))