Text before Formula

Lovingmags

Hi Everyone,

Please can I use smartsheet to achieve inserting a text before a formula just as can be done in excel ="The Total is"&Sum(E4:G18)

and the answer the reads The Total is 19

Thanks

Tammy_Bentz

Yes, the following is an example of a formula I use to derive the description of a risk which pulls in data from multiple cells