=if(or(isblank( issue

vipa2000
✭✭✭✭
Viewed a number of threads and cannot seem to understand why I am getting unparseable?
=IF(OR(ISBLANK(Finish1), Start1 < Finish1, "OK", "Start>Finish"))
Help appreciated.
Best Answer
-
Thank you.
Answers
-
Hi!
You are missing the true and false arguments for the IF statement.
Second, I don't get your last 2 arguments for the OR statement. you cannot put "OK", it has to be linked to a range or cell like Finish1="OK" and Start1>Finish1 for the last argument. That's where the unparseable comes from.
-
Thank you.
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!