How to combine IF, TODAY, OR, ISBLANK functions?
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!
Best Answer
-
Give this a try
=IF(ISBLANK([Completion Date]@row), "π΄ Not Certified", IF(TODAY() < [SH Next Training Due Date]@row, "π’ Certified", "π΄ Expired"))
Answers
-
Give this a try
=IF(ISBLANK([Completion Date]@row), "π΄ Not Certified", IF(TODAY() < [SH Next Training Due Date]@row, "π’ Certified", "π΄ Expired"))
-
Thank you so much! It worked!
-
Happy to help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!