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?
Solved! Go to 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
@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
Thank you. The formula works!
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |