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")
Answers
-
Got it!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!