Profile Pic using Data (if/then)

Report a Bug
16

something like this:

={"Default Image";arrayformula(if(len(A2:A), A2:A, "https://AVATARURL.com/"&B2:B))

Where A2:A is the image upload and B2:B is a unique ID to the user profile. Email address or Row ID. Avatar URLs can be any of the ones we found here:

1 Like