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
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 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!