Help with IF(AND(ISBLANK statement
Hey there, looking for help with this formula:
=IF(AND(ISBLANK([Orientation Appointment]3)), [HR RedCarpet Green Light]3=0), "Red", "Green")
Trying to get it to read a Red ball if "Orientation Appointment" cell is blank AND if "HR RedCarpet Green Light" cell is not checked, but I seem to be doing something wrong.
Help Article Resources
Check out the Formula Handbook template!