Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Text added in summary/calculation
In the video by Robin Sherwood demonstrating card view he shows his template with Summary tabs visible in the swimlanes. How does he manage to present the (50 secs in) summary with "Units: 1750" I think this might be more of a string just added to the front/back of the formula in his grid view for line 2 quantity (20 secs). I see how the calculation can be done, but how does he add the "Units:" prefix?
(https://www.youtube.com/watch?v=3tiSlQGP7Ww)
Thanks
Comments
-
Hi Tony-- Robin accomplished this by concatenating the "Units:" prefix with the result from his formula. You can do this similarly to the example below:
="Units: " + COUNTIF(State5:State110, "Pending Sale")
Hope that helps!
-
thanks Kennedy I managed to get to that stage with the same approach in the end, but thought there might have been a basic function, but that does it fine and all happy thanks.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives