IF(ISBLANK with IF work on one Column but not the other
Hello,
I was looking all over the Community page and I was able to find the help I needed to make my statement work but when I changed the column in the statement it would stop working. I was hoping someone could explain the difference to me.
Below are my examples.
1. Working statement
=IF(ISBLANK(task@row), "Not Started", IF(task@row = "100", "Complete", "In Progress"))
2. Not working statement
=IF(ISBLANK(% Complete@row), "Not Started", IF(% Complete@row = "100", "Complete", "In Progress"))
Thank You
Best Answer
-
Hi,
2. Isn't working because your % Complete column name includes a % character and it wouldn't work if there were any space or numbers.
When it includes numbers or have any spaces you must wrap it with Square brackets [ ]
Try this.
=IF(ISBLANK([% Complete]@row), "Not Started", IF([% Complete]@row = "100", "Complete", "In Progress"))
Did it work?
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
Hi,
2. Isn't working because your % Complete column name includes a % character and it wouldn't work if there were any space or numbers.
When it includes numbers or have any spaces you must wrap it with Square brackets [ ]
Try this.
=IF(ISBLANK([% Complete]@row), "Not Started", IF([% Complete]@row = "100", "Complete", "In Progress"))
Did it work?
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thank you that helped
-
Excellent!
Happy to help!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives