I have a google sheet with 5 cells : image1, ...

AppSheet AppSheet Q&A
1

I have a google sheet with 5 cells : image1, image2,image3,image4,image5.

When my app opens I only want to see image1, if image1 contains an image then image2 should become visible. So iamge 2 to 5 should have a condition, only become visible if the preceding image cell contains an image, if not then stay hidden.

Can anyone help with the expression? Thanks

2

Try this:

Under Data → Columns → Edit Column Definition → Show_If, type ‘ISNOTBLANK([image#])’ for each column, replacing # with the preceding column’s number.

If this isn’t what you’re looking for, let me know.

3

Works like a dream… Thank You