Nest if/or formula
Options
Hi Community, I need your help... I'm trying to create a formula that captures "No Action Taken". The individual IF Statements are as follows:
If [Flu Vaccination Date] is "Blank" OR
If [Flu Vaccination Date] is ">=" [Flu Vaccination Date]$1 OR
If [Flu Declination Date] is "Blank" OR
If [Flu Declination Date] is ">=" [Flu Vaccination Date]$1 THEN
[No Action Taken] = 1
Can you help?
Tags:
Answers
-
Try this...
=IF(OR(ISBLANK([Flu Vaccination Date]@row), [Flu Vaccination Date]@row >= [Flu Vaccination Date]$1, ISBLANK([Flu Declination Date]@row), [Flu Declination Date]@row >= [Flu Vaccination Date]$1), 1)
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!