If Not Blank Statement Help

JakeF

Hello,

I am trying to write a Column Function If statement in the "Task Status" column that will update my status to be "Complete" or "Incomplete" based on if certain cells on my smartsheet are blank or not.

So far this is the formula I've put together, but I can't quite get it to work. Would somebody be able to take a look at this? I also tried grabbing the whole range to make it easier, but that doesn't seem to work either.

=IF(AND(NOT(ISBLANK([Nurse Intake Completed]@row)), NOT(ISBLANK([Folders Created]@row)), NOT(ISBLANK([Added to Demand Tracker]@row)), NOT(ISBLANK([Add to Medical Chrona Tracker]@row)), NOT(ISBLANK([Add to Billing Chron]@row)), NOT(ISBLANK([Add to SR-HR Excel File]@row)), [Add New Entry to Billing System]@row), "Complete", "Incomplete")

JakeF

Got it!