Nested conditions in expression

AppSheet AppSheet Q&A
,
1

Hello,

Hello, I have a question regarding expressions. I have a form in which I filled in several fields with a color value (Green, Yellow, Red and Black), I would like to have a field of 6 or depending on the values entered, it displays a color.
Let me explain if in my field 1 it is green, my field 2 is Red, my field 3 is green the result of my field will be Red because there is a red in the previous field.
Hoping to have made myself understood

2

Hello,

Sorry I’m having difficulties understanding your requirement. I recommend that you share a screenshot of your table setup please and explain again what you’d like to achieve. Thanks

1 Like
3

I think I have a start of solution

IF(
OR([Site-Sol]=Noir,[Environnement]=Noir,[RĂ©sultat Structure]=Noir,[non structuraux]=Noir),Noir,
IF(
OR([Site-Sol]=Rouge,[Environnement]=Rouge,[RĂ©sultat Structure]=Rouge,[non structuraux]=Rouge),Rouge,
IF(
OR([Site-Sol]=Jaune,[Environnement]=Jaune,[RĂ©sultat Structure]=Jaune,[non structuraux]=Jaune),Jaune,
IF(
OR([Site-Sol]=Vert,[Environnement]=Vert,[RĂ©sultat Structure]=Vert,[non structuraux]=Vert),Vert,
IF(
OR([Site-Sol]<>Noir,[Environnement]<>Noir,[RĂ©sultat Structure]=Noir,[non structuraux]<>Noir),Noir,
IF(
OR([Site-Sol]=Noir,[Environnement]<>Noir,[RĂ©sultat Structure]<>Noir,[non structuraux]<>Noir),Noir,
IF(
OR([Site-Sol]<>Rouge,[Environnement]<>Rouge,[RĂ©sultat Structure]=Rouge,[non structuraux]<>Rouge),Rouge,
IF(
OR([Site-Sol]=Rouge,[Environnement]<>Rouge,[RĂ©sultat Structure]<>Rouge,[non structuraux]<>Rouge),Rouge,
IF(
OR([Site-Sol]<>Rouge,[Environnement]=Rouge,[RĂ©sultat Structure]<>Rouge,[non structuraux]<>Rouge),Rouge,
"-")))))))))
4

Et qu’est-ce que t’en penses de celle-ci?

https://help.appsheet.com/en/articles/2355961-ifs

2 Likes
5 
any(
  intersect(
    list("Noir", "Rouge", "Jaune", "Vert")
    list([Site-Sol], [Environnement],[RĂ©sultat Structure], [non structuraux])
  )
)