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

[Carlos-Werq]

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?

[Justin_Barrett · Accepted solution]

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}
  )
)

[Carlos-Werq]

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

Cheers.