Combine column with static URL

I know there is an answer out there in the community for what I want to do but I am not quite sure what I need to search to find it.

I want to use a formula to create a custom URL. The beginning of the URL is always the same but the ending will change. So for example, I want everything to start with www.google.com/ and then we would add a number from another column on to the end so it ends up as www.google.com/12345678. What is the formula to make this happen?

Additionally to make it more complicated, is there a way to make that beginning of the URL change depending on what is selected in yet another column AND add on that variable column cell from above?? So for example, if Food is selected in one column, the formula would make the url www.google.food.com/12345678 but if drink is selcted, it would make the formula www.google.drink.com/12345678. We would only have 3 drop down options so it isnt open ended.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!