IF(ISBLANK with IF work on one Column but not the other

thunt06

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

 

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

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!