Formula to return non-blank value from multiple cells
MegBLLC
✭✭
I have a number of columns in a row and only one of them will be not blank at any one time. I'd like to program another cell that will "look" at these cells and return only the value of the cell among those columns that is not blank. Is this possible?
Answers
-
Hi @MegBLLC
It is possible. You can write a nested IF formula to check the columns one by one and collect the value if it is not blank. Something like =IF([Column 1]@row <> "", [Column 1]@row, IF([Column 2]@row <> "", [Column 2]@row….
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 36 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!