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

  • Gia Thinh
    Gia Thinh ✭✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!