EXPRESSION IF NOT done all the actions, DO THIS

[Sara_Bertomeu]

HI,

I'm looking for a formula that seems like if the data do not find any of the actions mentioned in the next formula do XXX, in my case : SUBSTITUTE([COLOR],[COLOR],"Blue")  

But I do not know if I have to use IF NOT or write an IF at the beginning, ending with that....

The formula it's:

IFS(

CONTAINS([Title],"1BK"),"Green",
CONTAINS([Title],"1ABN"),"Green",
CONTAINS([Title],"D1"),"Green",

CONTAINS([Title],"2D2"),"Orange",
CONTAINS([Title],"2ABN2"),"Orange",
CONTAINS([Title],"2BK2"),"Orange",
CONTAINS([Title],"2BK2"),"Orange",
CONTAINS([Title],"D2.2"),"Orange",

CONTAINS([Title],"D2"),"Purple",
CONTAINS([Title],"2BK"),"Purple",
CONTAINS([Title],"2ABN"),"Purple",

AND([PAX]= "3",CONTAINS([COLOR],"Orange")),SUBSTITUTE([COLOR],[COLOR],"Yellow"),

)

Can you help me??? Thanks in advance

[dbaum]

I don't follow what you need to accomplish. Is your expression for a column's App formula property? You mention "actions"; does your question involve an AppSheet action? Maybe post a screenshot of where you're entering this expression.

One note is that the following part of your expression is equivalent to just using "Yellow" on its own without the SUBSTITUTE function. In your expression, that function is replacing the entire value of the [COLOR] column with "Yellow". It would be the same as using any verbatim string for the function's first two arguments (e.g., SUBSTITUTE("abc","abc","Yellow"))--the use of the {COLOR] column is irrelevant.

SUBSTITUTE([COLOR],[COLOR],"Yellow")