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
Solved! Go to Solution.
Et qu'est-ce que t'en penses de celle-ci?
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
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,
"-")))))))))
Et qu'est-ce que t'en penses de celle-ci?
any(
intersect(
list("Noir", "Rouge", "Jaune", "Vert")
list([Site-Sol], [Environnement],[Rรฉsultat Structure], [non structuraux])
)
)
User | Count |
---|---|
37 | |
26 | |
23 | |
17 | |
14 |