LinkBack URL
About LinkBacks
I have a formula for a column in a table "=IF(ISTEXT([Version]), "MD", "NA")
But this yields "MD" for every column. Even when Version is empty.
What am I doing wrong?
IF(ISTEXT is not working
I have a formula for a column in a table "=IF(ISTEXT([Version]), "MD", "NA")
But this yields "MD" for every column. Even when Version is empty.
What am I doing wrong?
You sure Version is empty and not an "" or " "? =ISTEXT() will return false if the cell is empty. You can try ISBLANK() to double check.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
Pauleyb,
You nailed it. SQL was pulling in " " instead of nothing.
Fixed with adding "IF([VERSION]=" ", NA,...."
to the beginning of the formula.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks