Text before Formula

Lovingmags

Lovingmags ✭

12/07/22 in Formulas and Functions

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

0 ·

Answers

Tammy_Bentz ✭✭

12/07/22

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

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Visual Status Alert
Hello All! I hope this is an easy soulution. Can anyone assist me with creating at status alert based off of today's date and a start date? I want the Delay Status to automatically put the status listed and color the cell. If a Cleard to Start has a check mark, then it shows no delays and color coded green. At some point,…
Exact
I just want to compare 2 cells (=exact in excel) if they are exact then true, if not then false, why am I struggling
Finding the oldest date on multiple sheets and also based on text in another cell
I have 2021, 2022, 2023, 2024, and 2025 sheets with different departments' requests for action (RFAs). I am looking for a formula to show me the oldest open RFA for each department. Some departments will be in 2021, but some will be in 2024. A sheet summary formula is not what I am looking for. I need a reference sheet…