Image Picker URL not linking with row

[Jeff_Hager]

Potential security issue: ability to clear users cache needed

Are you using the importrange and then adding additional columns in the google sheet? If so, just like using a UNIQUE formula, you run the risk of data becoming misaligned because the data in the importrange is not directly linked to the row that contains the additional column data. I avoid doing things like this at all costs because it’s too easy to have corrupted data if things change and become misaligned. Instead I have used scripts in the past to only add new names to a sheet if the name…