Hide a column if not blank

Is it possible to hide a column if not blank ?

Solved Solved
0 3 76
1 ACCEPTED SOLUTION

If you want to hide a column in a table, using a Show If expression will only prevent the value from appearing when the condition is met. However, there may still be rows where that column contains values. If your goal is to hide the column entirely, you need to manage it from the views.

Regarding the expression to hide a value, look into ISNOTBLANK() or ISBLANK().

As I mentioned, if you want to hide an entire column, manage it from the views (instead of displaying columns automatically, choose manual and remove it) or create a slice with the condition ISBLANK([Column]). This will filter out all records where that column is blank.

Then, create a view based on that slice.

 

View solution in original post

3 REPLIES 3

If you want to hide a column in a table, using a Show If expression will only prevent the value from appearing when the condition is met. However, there may still be rows where that column contains values. If your goal is to hide the column entirely, you need to manage it from the views.

Regarding the expression to hide a value, look into ISNOTBLANK() or ISBLANK().

As I mentioned, if you want to hide an entire column, manage it from the views (instead of displaying columns automatically, choose manual and remove it) or create a slice with the condition ISBLANK([Column]). This will filter out all records where that column is blank.

Then, create a view based on that slice.

 

have you solved this?

Not yet @Gustavo_Eduardo i need to solve first this other issue:

Expression was unable to be parsed: Unterminated string

If you've time / want ๐Ÿ™‚

Ciao

Top Labels in this Space