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

expressions
(MM Group) #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

(Jacob Lin [AppSheet]) #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.

(MM Group) #3

Works like a dream… Thank You