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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!