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

[MM_Group]

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_AppSh]

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]

Works like a dream… Thank You