# How to combine IF, TODAY, OR, ISBLANK functions?

Options
ā­ā­

Hello,

I am having trouble putting together a formula for showing when my employees have been certified or not. Here is the formula I am using

=IF((ISBLANK([Completion Date ]@row), "š“ Not Certified"), IF((TODAY() < [SH Next Training Due Date]@row, "š¢ Certified", "š“ Expired")))

When an employee completes their training I enter the Completion Date, that date is also used for another formula to calculate when the certification expires SH Next Training Due Date (in 2 years from completion date).

What I want is when I enter the Completion Date, which in turn tells me when the Next Training Due Date is, that as long as it is not past the next training due date/expiration date it returns "š¢ Certified". When the Next Training Due Date is today or in the past, have the formula return "š“ Expired". But when the Completion Date cell is blank, I want it to return as "š“ Not Certified".

I dont know which formulas to use in order to achieve those results. I have already tried multiple ways. Currently i am getting an error message that says "the column formula syntax is not quite right"

Any help would be very appreciated thank you!

• ā­ā­ā­ā­ā­
Options

Give this a try

=IF(ISBLANK([Completion Date]@row), "š“ Not Certified", IF(TODAY() < [SH Next Training Due Date]@row, "š¢ Certified", "š“ Expired"))

• ā­ā­ā­ā­ā­
Options

Give this a try

=IF(ISBLANK([Completion Date]@row), "š“ Not Certified", IF(TODAY() < [SH Next Training Due Date]@row, "š¢ Certified", "š“ Expired"))

• ā­ā­
Options

Thank you so much! It worked!

• ā­ā­ā­ā­ā­
Options

Happy to help!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!