I have to use the formula IF(ISBLANK(X);"FALSE";X). it is not working because the data type of X and "false" is string and that of X is Boolean. How can I make it work.. I think it should not have been the constraint. when I use the same data type it works but not if the data type is different. Please let me know how can I make it work without changing the data type of the columns.
Please sign in to leave a comment.