Ternary operator

[Quentin_Decaune]

Hi,

Usage example:

INDEX(SELECT(...), 1) || 0

This would have the same result as:

IF(ISBLANK(INDEX(SELECT(...), 1)), 0, INDEX(SELECT(...), 1))

It would be much clearer and possibly a performance gain as you could exec one query instead of two.

[Marc_Dillon]

I thought about posting this exact request a week or so ago. But instead I posted the following one. The reason being that Appsheet generally follows spreadsheet-esque formulas, instead of coding language type syntax. I don’t believe any spreadsheet systems have a ternary operator (but would happily be proven wrong), but they do have IFERROR().

IFBLANK() or IFERROR() Feature Requests

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]

[Steve]

https://www.google.com/search?q=ternary+operator