If Not Blank Statement Help

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")



Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!