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

edited 12/09/19 in Smartsheet Basics


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