How can I sum cells that include the abbreviation of states, but include commas in between?
As of right now I am summing selected cells, which then gives me everything that is in those cells. It is then merging them together, but I need it to include a comma if there is more than 1 cell that has information in it.
Best Answer
-
Try this instead:
=JOIN(COLLECT([Dash Columns]12:[Dash Columns]61, [Dash Columns]12:[Dash Columns]61, @cell <> ""), ", ")
Answers
-
@haley brianne Your screenshot is not really showing a lot. Can you recapture the screen shot and also give an example of what you want?
-
There should be a comma in between ME & DE. Those are abbreviations of states. @Eric Law
-
Can you provide the entire formula you are using?
-
=[Dash Columns]61 + [Dash Columns]60 + [Dash Columns]59 + [Dash Columns]58 + [Dash Columns]57 + [Dash Columns]56 + [Dash Columns]55 + [Dash Columns]54 + [Dash Columns]53 + [Dash Columns]52 + [Dash Columns]51 + [Dash Columns]50 + [Dash Columns]49 + [Dash Columns]48 + [Dash Columns]47 + [Dash Columns]46 + [Dash Columns]45 + [Dash Columns]44 + [Dash Columns]43 + [Dash Columns]42 + [Dash Columns]41 + [Dash Columns]40 + [Dash Columns]39 + [Dash Columns]37 + [Dash Columns]38 + [Dash Columns]36 + [Dash Columns]35 + [Dash Columns]34 + [Dash Columns]33 + [Dash Columns]32 + [Dash Columns]31 + [Dash Columns]30 + [Dash Columns]29 + [Dash Columns]28 + [Dash Columns]27 + [Dash Columns]26 + [Dash Columns]25 + [Dash Columns]23 + [Dash Columns]24 + [Dash Columns]22 + [Dash Columns]21 + [Dash Columns]20 + [Dash Columns]19 + [Dash Columns]18 + [Dash Columns]17 + [Dash Columns]16 + [Dash Columns]15 + [Dash Columns]14 + [Dash Columns]13 + [Dash Columns]12 @Paul Newcome
-
Try this instead:
=JOIN(COLLECT([Dash Columns]12:[Dash Columns]61, [Dash Columns]12:[Dash Columns]61, @cell <> ""), ", ")
-
Perfect, thank you @Paul Newcome !
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!