Concatenated Column or Helper Column Help
I have a concatenated column which we use as a summary of the row. I need to include another column called External in it but one of the drop down options is Not Applicable. Is there a way I can edit the formula so that it doesn't include any options which return this value? I'm also thinking I can just add a helper column which equals the External column but can exclude any Not Applicable values. I'm stumped on both counts so any help would be greatly appreciated!
=IFERROR(Region@row + "_" + Country@row + "_" + [Category]@row + "_" + "\"" + [Title]@row + "\"" + "_" + Location@row + "_" + [Start Date]@row, "")
Best Answer
Answers
-
Have you tried working in the SUBSTITUTE function?
=IFERROR(SUBSTITUTE(Region@row + "_" + Country@row + "_" + [Category]@row + "_" + "\"" + [Title]@row + "\"" + "_" + Location@row + "_" + [Start Date]@row, "N/A", ""), "")
-
To be sure you have another column called External with a drop down option? if I am correct then try this.
=IFERROR(Region@row + "_" + Country@row + "_" + [Category]@row + "_" + "\"" + [Title]@row + "\"" + "_" + Location@row + "_" + [Start Date]@row,+"_"+IF(External@row = "Not Applicable","",External@row),"")
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
Substitute function worked a treat, thanks Paul!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!