Welcome!

Can I join the results from formulas in 2 differing cells?

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!

Yes. Try a JOIN function

=JOIN(text_to_join, [delimiter])

The delimiter is optional.

I am getting an error message when attempting to export to excel
I am attempted to export to excel. I have two different smartsheet documents to export. One of them exported to excel fine, but not the other. This happened a few weeks ago. I make sure all columns were the correct size & no cells were hidden. "We have found a problem with (file) Do you want us to try and recover as much…
Need Help w/ Report View - Nothing Is Showing
Hello Smartsheet Community, I need some help with a report that I created and shared with a customer. The customer is not seeing any of the information that is pulling into the report. See screen shot below that the customer texted me. I do have the report filter only showing the customer their product pulling from our…
How can I hard code a cell based on a trigger?
BLUF: When I create an Invoice, I need the cell-link to my live price data to be severed. I currently have a Price sheet for my products that is updated frequently. I use Control Center to create Projects, which includes an Invoice sheet. I have a dropdown on my invoice sheet to select a product, and then I use Index…