#INVALID COLUMN VALUE for Isblank formula

mikeallen7

Hi. I am getting an #INVALID COLUMN VALUE response for the formula (=ISBLANK([Product's Guess at Dev Effort]@row). The column is defined and text/numbers.

Any suggestions on what I am doing wrong?

Thanks!

Mike TV

@mikeallen7

https://help.smartsheet.com/function/isblank?frame=0&nav=1

• This function is typically used inside of another function, for example: IF, COUNTIF, or SUMIF.

Examples:

=IF(ISBLANK([Units Sold]1), "Blank", "Not blank")

=IF(NOT(ISBLANK([Units Sold]2)), "Gained revenue","No Sale")

=IF(ISBLANK([% Complete]3), "Red")