If, Then Formula Needed
Options
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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!