Formula is to match

AppSheet AppSheet Q&A
1

Hi everyone
what I want to do with this formula is to match the RAMP column when the STATUS column is empty or OPEN. so far everything works.
I also want to hide the RAMP column in the FORM view but it doesn’t work!

OR(ISBLANK([status]), [status]=“OPEN”,CONTEXT(“ViewType”)<>“Form”)

2

Might be redundant: have you tried just the CONTEXT(“ViewType”)<>“Form” portion by itself?

Maybe also try using these:

OR(
ISBLANK([status]),
[status]=“OPEN”,
(NOT(CONTEXT(“ViewType”)=“Form”)
)

and

OR(
ISBLANK([status]),
[status]=“OPEN”,
(NOT(CONTEXT(“View”)=“ViewName”)
)

3

Try:

AND(OR(ISBLANK([status]), [status]=“OPEN”),CONTEXT(“ViewType”)<>“Form”)