AND not working beyond 2 logical expressions!
I feel like I'm taking crazy pills!!!
I have the following formula to change the value of a cell, to encourage the population of cells for a tracking sheet.
=IF(AND(ISBLANK(Designer6), ISBLANK([Designer Start]6), ISBLANK([Designer Finish]6), ISBLANK(SME6), ISBLANK(CRE6)), "Pending...", "Click Save to notify!")
It works, but only for the first two logical expressions (Designer6) and [Designer Start]6... on the example and the help page for the function, it shows three expressions... when I build, the helper window doesnt move beyond "logical_expression2"
Ive spent hours on this now, tried to get there by myself, I don't know at this point if its my syntax, or what.
Also, why is (Designer6) in parentheses and [Designer Start]6 in brackets with the number on the outside? Smartsheet did that not me.