If, Then Formula Needed

tylermh

I want a formula to check if an @row cell is blank. The cell referred to is circled in red.

If it is NOT blank, I want a default value populated in the cell with the formula (circled in green):

David Joyeuse

Hi @tylermh

If I read your formula in green correctly what you're looking for is this:

=IF(NOT(ISBLANK([Work Item Title]@row)), "Advancement Series","")

Hope it helped.

David Joyeuse

Hi @tylermh

If I read your formula in green correctly what you're looking for is this:

=IF(NOT(ISBLANK([Work Item Title]@row)), "Advancement Series","")

Hope it helped.

tylermh

Thank you, @David Joyeuse. That did the trick!