Can I join the results from formulas in 2 differing cells?
Dave-Cisco
✭✭
Hit a brick wall, but I'll try to explain as best I can.
Cell1 has a formula for a NUMERICAL sum for a row across [Column A] + [Column B]
Cell2 has a formula to return TEXT based on value of a single cell in [Column C]
My goal is to have a single cell to display contents of Cell1 and Cell2.
I think I can join them, but can't wrap my formula skills around it.
Any help or direction is appreciated!
Comments
-
Yes. Try a JOIN function
=JOIN(text_to_join, [delimiter])
The delimiter is optional.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives