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

Solved
Jump to Solution
1188 0
cancel
Showing results for
Search instead for
Did you mean:
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
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}
)
)
``````
2 Replies 2
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}
)
)
``````
5 - Automation Enthusiast

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

Cheers.