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):
Tags:
Best Answer

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.
Answers

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.

Thank you, @David Joyeuse. That did the trick!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!