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

Tony Coleman
Tony Coleman ✭
edited 12/09/19 in Archived 2016 Posts

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

Tags:
· Share on FacebookShare on Twitter

Comments

  • Kennedy Stomps
    Kennedy Stomps Employee

    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!

    · Share on FacebookShare on Twitter
  • Tony Coleman
    Tony Coleman ✭

    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.

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories