Help

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

Topic Labels: Formulas
Solved
Jump to Solution
1545 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Carlos-Werq
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

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

See Solution in Thread

2 Replies 2
Justin_Barrett
18 - Pluto
18 - Pluto

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Cheers.