Hi guys, very new to formulas so not sure if this is even possible and/or makes sense.
I have a web form that lets the user submit data for:
NEWS PIECE TITLE
NEWS PIECE FILE (UNC path)
Then, I send an Update Request to our website team who upload the "NEWS PIECE FILE" from the UNC path onto our website, and provides the HYPERLINK TO NEWS PIECE from our website in another cell.
So, I want to combine the cells "NEWS PIECE TITLE" and "HYPERLINK TO NEWS PIECE" into a third cell, which would be the News Piece Title as the text and the Hyperlink to News Piece as the cell's hyperlink.
Is this possible? Please let me know if I need to clarify anything.