Multiple Expressions for a column

[Alvin_Minaya]

Wondering if there’s a way to repeat an expression for a column.
Example:
IF([Avid Codecs]= “DNxHR 444 4096 * 2160 59.94 444.16 MB/s”, “444.16”, “0”)
Which means…
IF this condition is true:
…(The value of column ‘Avid Codecs’) is equal to (“DNxHR 444 4096 * 2160 59.94 444.16 MB/s”)
THEN use the value of:
…“444.16”
ELSE use the value of:
…“0”

Then repeat it with…

IF([Avid Codecs]= “DNxHR 444 4096 * 2160 50 370.51 MB/s”, “370.5”,0)

Which should give me this result
IF this condition is true:
…(The value of column ‘Avid Codecs’) is equal to (“DNxHR 444 4096 * 2160 50 370.51 MB/s”)
THEN use the value of:
…“370.51”
ELSE use the value of:
…“0”

Basically I want it to go to the Avid Codecs Column
Check what has been selected from the many options from this Enum Column.
And if such Codec was selected then that equals this result.
If nothing has been selected from Avid Codecs then the result is zero.

It works fine when there’s only one formula but I need it to be multiple because of the multiple options.

[Steve]

help.appsheet.com

SWITCH()

Chose-one conditional evaluation

help.appsheet.com

IFS()

First-match conditional evaluation

[Alvin_Minaya]

I tried those earlier they don’t work. Or maybe I missed something when writing the formula.
Can you write it in formula representing both so I can see the difference?

Example:
([Avid Codecs]=
“DNxHR 444 4096 * 2160 59.94 444.16 MB/s”, “444.16”, “0”
“DNxHR 444 4096 * 2160 50 370.51 MB/s”, “370.5”,0

How will you write the above in SWITCH or IFS because it didn’t work for me when I tried it?

[Steve]

What did you try?

[Alvin_Minaya]

IFS and SWITCH

[Marc_Dillon]

Alvin_Minaya:

Example:
([Avid Codecs]=
“DNxHR 444 4096 * 2160 59.94 444.16 MB/s”, “444.16”, “0”
“DNxHR 444 4096 * 2160 50 370.51 MB/s”, “370.5”,0

How will you write the above in SWITCH or IFS because it didn’t work for me when I tried it?

SWITCH( [[Avid Codecs],
“DNxHR 444 4096 * 2160 59.94 444.16 MB/s”, “444.16”,
“DNxHR 444 4096 * 2160 50 370.51 MB/s”, “370.5”)

[Alvin_Minaya]

That’s the exact formula I wrote.
It doesn’t work.

Alvin J Minaya

[Suvrutt_Gurjar]

An IFS () function as mentioned by @Marc_Dillon should work. In case of SWITCH() statement, I believe there needs to be a default value in the end after all expected value, expected result pairs.
SWITCH( [[Avid Codecs],
“DNxHR 444 4096 * 2160 59.94 444.16 MB/s”, “444.16”,
“DNxHR 444 4096 * 2160 50 370.51 MB/s”, “370.5”, “default value”)

[Marc_Dillon]

I would suspect that the string isn’t matching the value in [avid codecs] then. Maybe try using CONTAINS within an IFS in order to just match a substring, such as the “444.16” portion.

IFS (
CONTAINS([avid codecs] , “444.16”) , “444.16”,
CONTAINS([avid codecs] , “370.51”) , “370.5”,
…