How do I add text to a formula

My current formula below works, and returns the value, 25%. But I want to add specific text to the value returned. So it should read, 25% - Milestone 1, or Milestone 1 - 25%
=INDEX({Milestone 1 - Preliminary Design Range 1}, MATCH([Activity ID]@row, {Milestone 1 - Preliminary Design Range 2}, 0))
Thanks.
Best Answer
-
Just add the text you want in quotes, than a plus sign, than the formula text.
="Milestone 1 - " + INDEX({Milestone 1 - Preliminary Design Range 1}, MATCH([Activity ID]@row, {Milestone 1 - Preliminary Design Range 2}, 0))
Or...
=INDEX({Milestone 1 - Preliminary Design Range 1}, MATCH([Activity ID]@row, {Milestone 1 - Preliminary Design Range 2}, 0)) + " - Milestone 1"
You can see an explanation of a similar use case in this video https://youtu.be/g9eap8EjFTI?t=272
Dan Palenchar |Β School of Sheets Solutions ConsultingΒ (Smartsheet Aligned Gold Partner)
Smartsheet Consulting Inquiries:Β schoolofsheets.com/workwithus
Smartsheet Tutorial Videos:Β schoolofsheets.com/youtube
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/π‘Insightful, β¬οΈ Vote Up, β€οΈAwesome!
Answers
-
Just add the text you want in quotes, than a plus sign, than the formula text.
="Milestone 1 - " + INDEX({Milestone 1 - Preliminary Design Range 1}, MATCH([Activity ID]@row, {Milestone 1 - Preliminary Design Range 2}, 0))
Or...
=INDEX({Milestone 1 - Preliminary Design Range 1}, MATCH([Activity ID]@row, {Milestone 1 - Preliminary Design Range 2}, 0)) + " - Milestone 1"
You can see an explanation of a similar use case in this video https://youtu.be/g9eap8EjFTI?t=272
Dan Palenchar |Β School of Sheets Solutions ConsultingΒ (Smartsheet Aligned Gold Partner)
Smartsheet Consulting Inquiries:Β schoolofsheets.com/workwithus
Smartsheet Tutorial Videos:Β schoolofsheets.com/youtube
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/π‘Insightful, β¬οΈ Vote Up, β€οΈAwesome!
-
@Dan Palenchar Thank you very much! Works perfectly :-)