How do I add a space in a reference formula? I want the space to display between the two values that
Good Afternoon,
I have built an event calendar tracker. I want the display name on the calendar to include information from two columns of data. The formula I am using for calendar display is =Location1 + [Event Name]1. In the calendar display column I want a space between the location and event name.
Best Answer
-
=Location1 + " " + [Event Name]1
Answers
-
=Location1 + " " + [Event Name]1
-
Thank you.
-
No problem. Just a hint, if you are referencing something on the same row you can use the @row reference.
=Location@row + " " + [Event Name]@row
This speeds up the sheet, and is a more professional way to build your formulas. The difference is if you use a row number, the program has to update each formula individually on refresh which can result in a significant performance decline for larger sheets.
Not that you probably need to do this for the sheet you are building, but it is a good habit to get in.
-
how would you display multiple spaces? " "+" "+" " etc...?
I know char(9) isn't recognized...
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!