Dynamic Show_if Column

[ChrisCTL]

Hey everyone,

I have a column [Question] that I only want to show in a slice depending on the value of another column [ABC] but I want it hidden if the other column is empty…

So if column [ABC] (Type=text) has a value (this value is different in most rows)
Then column [Question] (Type=ENUM) will show,
If [ABC] is blank then column [Question] will be hidden

Hopefully this makes sense…

Cheers

[Suvrutt_Gurjar · Accepted solution]

You could write NOT(ISBLANK([ABC])) or ISNOTBLANK([ABC]) in the show_if constraint of the [Question] column.

help.appsheet.com

ISBLANK()

Is value absent?

help.appsheet.com

ISNOTBLANK()

Is value present?

[Steve]

For reference:

help.appsheet.com

Show_If Column Constraint

Conditionally show or hide a column value.

[ChrisCTL]

@Suvrutt_Gurjar
Worked perfectly, thanks heaps