IFBLANK() or IFERROR()

I feel like I use this enough that a specialized wrapper expression would be helpful. IFERROR() exists in GSheets, and does exactly what I’m wanting, but maybe IFBLANK() is more in line with Appsheet expression naming.

Basically,

IFBLANK( [column] , [second-column] )

…is equivalent to:

IF( ISBLANK( [column] ) , [second-column] , [column] )

…just a lot shorter, especially when you need to use a longer expression in place of [column]

ANY(LIST([column], [second-column]) - LIST(""))
3 Likes

That’s a good trick, thanks for pointing it out. However, it doesn’t solve one of the main reasons for my request, which is expression readability.

2 Likes