show if formula

[paula]

Hi,

I have multiple [position] column for which if they are "manager", the next column need not to display. But this formula works only with the next statement. When choosing "manager" in [acctg position], the [manager] column next still shows.

[dbaum]

A column's values are displayed when the column's Show if expression returns Yes. If you want a Column C to show when "Manager" is the value in either Column A or Column B, then your current expression may be the opposite of what you need. Consider one of the following expressions, which are equivalent:

OR([Acctng Position] = "Manager", [Admin Position] = "Manager")

IN("Manager", LIST([Acctng Position], [Admin Position]))

[paula]

I need the opposite. So equivalent to your first one, my formula was what I screenshot and the problem.

And either way, 

It still displays whatever I choose in the position. 😞

[dbaum]

As before, I'm not sure I understand your requirement. If you share screenshots of the AppSheet table's list of columns and explicitly indicate which column you want to show or hide based on which other column(s), likely someone can provide direct advice.

Meanwhile, in case it's relevant, I note that in your most recent screenshot the column labeled "Manager" does not have the value "Manager" that is referenced in your expression. Perhaps you've unknowingly swapped column names and column values in your expression? If so, you might need something like one of the following equivalent expressions:

NOT(OR([Manager] = "Acctg. Manager", [Manager] = "Admin Manager"))

AND([Manager] <> "Acctg. Manager", [Manager] <> "Admin Manager"))

NOT(CONTAINS([Manager], "Manager"))

[paula]

---

@dbaum wrote:

If you want a Column C to show when "Manager" is the value in either Column A or Column B

---

I just want to reiterate this, the thing is, I want column C to NOT show when "Manager" is the value in the prior column.

Which is, in the last formulas you gave, it should be like the first one but the condition I put is the [Acctg Position] to NOT be "Manager" for Show IF expression  of [Manager] to be true.

Anyway, using that, it still gives me the result that even though [Acctg Position] is Manager, [Manager] column still shows up. Can you see why is that? Thanks again!

[JuneCorpuz]

---

@paula wrote:

I want column C to NOT show when "Manager" is the value in the prior column.

---

I think it's better for you to share the column names and table structure so we can better understand your requirements. What is Column C andprior column?

[paula]

'Column C' is [Manager] and 'Prior' is [Position]. I want that if the position is already Manager, then the column [Manager] would not show anymore

[JuneCorpuz]

Try this formula in the Show_If of [Manager]

NOT(CONTAINS([Position], "Manager"))

[paula]

Works, yes, sorry but I forgot to mention I have separated different [Position]s per department like [Acctg Position], [HR Position], [MIS Position], so on. The formulas above when using multiple values doesn't work

[JuneCorpuz · Accepted solution]

AND(
	NOT(CONTAINS([Position], "Manager")),
	NOT(CONTAINS([Acctg Position], "Manager")),
	NOT(CONTAINS([HR Position], "Manager")),
	NOT(CONTAINS([MIS Position], "Manager"))
)

[paula]

Thank you so much! I didn't try AND, instead kept on using OR cause I thought ALL should be true all at once for it to be true. So that was it all this time, big thanks!