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

Find more posts tagged with

Sheets

IT & Operations

Media & Entertainment

Accepted answers

Andrée Starå

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

All comments

Andrée Starå

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

thunt06

Thank you that helped

Andrée Starå

Excellent!

Happy to help!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.