IF Expression help

[SKETCHwade]

Im trying to use an expression to auto fill a column based on the selection of a previous column.

This is what I currently have but appsheet cannot compare “text with list”

IFS([Equipment] = LIST(
W4,
W8),

Artic Dump Truck,

[Equipment] = LIST(
W5,
W7)
)

[Gil]

Your condition [Equipment] = LIST(W4,W8) is checking if the value in the Equipment column is a list containing the values “W4” and “W8”, and only those values. That’s probably not what you’re trying to do, and if the Equipment column is not a list you’d see an error (like the one you’re seeing).
What are you trying to do exactly? Are W4 and W8 referring to cells in you spread sheet?

[SKETCHwade]

Ok Thank you,

W4 and W8 are seperate options for the equipment column.
If it matches then the column in which this formula is located should return
“Artic Dump Truck”

then I want many more options

so W31 might change it to Dozer

and W40 through 50 might be Excavator

[SKETCHwade]

This is another way to explain it. I want this formula to be more efficient. Im sure theres a way.
Instead of the listed W# it will be much bigger list of numbers.

IFS(
[Equipment] = W4,
Artic Dump Truck,
[Equipment] = W5,
Artic Dump Truck,
[Equipment] = W6,
Dozer,
[Equipment] = W7,
Dozer,
[Equipment] = W8,
Excavator,
[Equipment] = W9,
Excavator,
)

[Steve]

SWITCH(
  [Equipment],
  "W4", "Artic Dump Truck",
  "W5", "Artic Dump Truck",
  "W6", "Dozer",
  "W7", "Dozer",
  "W8", "Excavator",
  "W9", "Excavator"
)

[SKETCHwade]

Thank you Steve! This is what I have gone with. I still feel like there should be another way that doesn’t require me to write artic dump truck 20 times but it will do haha

[Steve]

@Heino_Matthee’s suggestion is a good one, too.

[Lynn]

Hi @SKETCHwade Maybe you could put all that data into a table.

[SKETCHwade]

Hi @Lynn I might have to do this if I can’t come up with an expression based solution. I’d like to reduce the number of tables as multiple people will view the spreadsheet and i’m sure they will get confused

[Heino_Matthee]

Try the IN expression.
IFS(IN([Equipment], LIST(W4, W8)), Arctic Dump Truck, etc)