Image Viewer
=if(isblank(V2),"",left(replace(V2,26,7,"thumbnail?id"),71))
=importrange("https://docs.google.com/spreadsheets/d/1GqWE_hl2Y_RjIgD4-Vnok-c_BENnsESUWPWhbiqLFto/edit#gid=1330226964","DataSource!A3:A382")
=if(isblank(D2),"",trim(D2))
=REPLACE(trim(D2),26,7,"thumbnail?id=")
=if(isblank(D3),"",REPLACE(trim(D3),26,7,"thumbnail?id="))
=if(isblank(F3),"",left(trim(F3),71))
Image Viewer
https://lookerstudio.google.com/reporting/2e011255-e5a8-4dda-bf66-9686617d44bd/page/K7bsD
https://lookerstudio.google.com/reporting/9cde7cb5-4b4d-48ac-9cbe-186feb75c222
https://lookerstudio.google.com/reporting/2d82d33a-7fd3-45b6-9a2e-75db12fb9e66/page/xzdsD
Youtube Viewer
=replace($G$1,24,11,RIGHT(A2,11))
http://i3.ytimg.com/vi/wes-QNVsJfg/hqdefault.jpg
https://www.get-youtube-thumbnail.com/
=replace($AO$1,24,11,RIGHT(AF2,11))
=RIGHT(A2,11)
=replace($G$1,24,11,B2)
=replace($AO$1,24,11,RIGHT(AF2,11))
https://lookerstudio.google.com/reporting/2d82d33a-7fd3-45b6-9a2e-75db12fb9e66/page/xzdsD
No comments:
Post a Comment