Formulla for blank column

Vinton Douglas

I want a status column to display "gray" bubble when the row is blank. can anyone help with a formulla?

Tatiana Kardosova

Hi Vinton.

I am not sure if I understand question correctly (do you mean by bubble the dot) but please try following:

Formula: =IF(AND(ISBLANK([#1]@row), ISBLANK([#2]@row)), "Gray")

Tatiana

Tatiana Kardosova

Hi Vinton.

I am not sure if I understand question correctly (do you mean by bubble the dot) but please try following:

Formula: =IF(AND(ISBLANK([#1]@row), ISBLANK([#2]@row)), "Gray")

Tatiana

Vinton Douglas

Much appreciated. Works great.