Skip to main content
Solved

How can I best combined a column with a switch formula and another with a if/and formula?

  • November 1, 2022
  • 2 replies
  • 33 views
C
Forum|alt.badge.img+3

Hello! I have two fields. One titled: Naming Convention Help w/ this formula:

SWITCH({Naming Convention},"Series",{Standard File Name (Series) Template},

"Movie",{Movies - Naming Convention},

"Awards & FYC",{Awards - Naming Convention},

"Free",{Free Series - Naming Convention},

"Series V2",{Series Naming Convention V2},

"Series V3",{Series Naming Convention V3},

{Standard File Name (Series) Template})

and another formula field titled Naming Convention Final:

IF(AND({Language}&"" = "en-US", {Naming Convention}="Series V3"),{Series Naming Convention V3},{Naming Convention Help})

I’m completely stumped on this one and need to reduce the number of fields in my base, any way to combined these two fields into one?

Best answer by Justin_Barrett

Does this work for what you need? This was created by copying the SWITCH() function and completely replacing the reference to {Naming Convention Help} in the IF() formula.

IF(
  AND({Language}&"" = "en-US", {Naming Convention}="Series V3"),
  {Series Naming Convention V3},
  SWITCH({Naming Convention},
    "Series",{Standard File Name (Series) Template},
    "Movie",{Movies - Naming Convention},
    "Awards & FYC",{Awards - Naming Convention},
    "Free",{Free Series - Naming Convention},
    "Series V2",{Series Naming Convention V2},
    "Series V3",{Series Naming Convention V3},
    {Standard File Name (Series) Template}
  )
)

2 replies

Justin_Barrett
Forum|alt.badge.img+21
  • Justin_Barrett
  • Inspiring
  • Answer
  • November 1, 2022

Does this work for what you need? This was created by copying the SWITCH() function and completely replacing the reference to {Naming Convention Help} in the IF() formula.

IF(
  AND({Language}&"" = "en-US", {Naming Convention}="Series V3"),
  {Series Naming Convention V3},
  SWITCH({Naming Convention},
    "Series",{Standard File Name (Series) Template},
    "Movie",{Movies - Naming Convention},
    "Awards & FYC",{Awards - Naming Convention},
    "Free",{Free Series - Naming Convention},
    "Series V2",{Series Naming Convention V2},
    "Series V3",{Series Naming Convention V3},
    {Standard File Name (Series) Template}
  )
)
C
Alexey_Gusev
A
C
Forum|alt.badge.img+3
  • Carlos-Werq
  • Author
  • Participating Frequently
  • November 7, 2022

Thank you, Justin! This works wonderfully, and the team is thrilled!

Cheers.

Justin_Barrett
Terms & ConditionsAccessibility statement