Formula Help
I have this formula: =IF(CONTAINS("Resource", [Component Type]@row), LOWER(Curriculum@row + IF([Grade/Level]@row <> "", ".g" + [Grade/Level]@row) + IF(Module@row <> "", ".m" + Module@row) + IF([Concept/Topic/Arc]@row <> "", "." + [Concept/Topic/Arc]@row) + IF(Lesson@row <> "", ".l" + Lesson@row) + "." + LOWER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([Public Facing Title]@row, " ", ""), CHAR(34), ""), "-", ""), ":", ""), CHAR(22), ""), "!", ""), "?", ""), CHAR(44), ""), "á", ""), CHAR(40), ""), CHAR(41), ""), CHAR(39), ""), "'", ""), "—", ""), "...", "") + IF([Resource/Object Type]@row = "Digital Assessment", ".dig"))))
I want to add to the formula so that New Strapi Item Code for Module 1 Tips for Families populates the same output for the same translated versions of Module 1 Tips for Families. This formula will need to work for module # changing. There are 14 languages and those will remain the same per module. Right now the Strapi Item Codes for each translation show the language. I need al.g1.m1.module1tipsforfamlies to show for each translation.
Answers
-
Hi @kpierson109
I got this idea: add a new "Shorten Title" column with the formula below, then use it as input for your current formula in the "New Strapi Item Code" column. Hope it works for you.
=IF(FIND(" (", [Public Facing Title]@row) = 0, [Public Facing Title]@row, LEFT([Public Facing Title]@row, FIND(" (", [Public Facing Title]@row) - 1))
Gia Thinh Technology - Smartsheet Solution Partner.
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!