Show IF Formula

[maryb031423]

Hey guys! I have a question about the showIF formula. I used this formula "IF(IN([Id], Request[Id]), true, [Category] <> "New Equipment, Ingredients order, Suggestion")"  to hide the column "Picture of Item" in the form when you select one of these categories. But it only works with the "New equipment" category. Can you help me with this formula?  

[WillowMobileSys · Accepted solution]

---

@maryb031423 wrote:

...[Category] <> "New Equipment, Ingredients order, Suggestion" ...

---

In the excerpt above, is the quoted text an actual SINGLE category name or is it a list of categories? Can you show us you Category column definition?

If its a list then you implement it like this:

IF(IN([Id], Request[Id]), 
   true, 
   NOT(IN([Category], {"New Equipment", "Ingredients order", "Suggestion"}))
)

 Note that these are equivalent

• {"New Equipment", "Ingredients order", "Suggestion"} 
• LIST("New Equipment", "Ingredients order", "Suggestion")

[maryb031423]

Thank you. The formula works!