How do I add text to a formula

SJTA

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.

SoS | Dan Palenchar

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

SoS | Dan Palenchar

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

SJTA

@Dan Palenchar Thank you very much! Works perfectly :-)