New answers tagged importhtml
0
Try this formula:
=query({importhtml("https://fbref.com/en/share/SxTNE","table",0)},"Select Col3")
There are several reasons why your formula was not successful:
"special" characters vs "normal" characters: often when formula are copied from the web, they can include characters that are not conventional ...
0
I think this is what @Rubén was getting at. This formula will automatically change to reflect the current date:
="https://www.poisonfoot.com/"&day(TODAY())&"-"&month(TODAY())&"-"&year(TODAY())&"/"
Value = https://www.poisonfoot.com/31-12-2020/
Leading zeros
The values of day, month and year in ...
Top 50 recent answers are included
Related Tags
importhtml × 59google-sheets × 58
importxml × 15
formulas × 13
google-apps-script × 9
google-sheets-query × 6
importdata × 3
google-sheets-arrayformula × 2
importrange × 2
automation × 2
xpath × 2
google-apps × 1
regex × 1
html × 1
concatenate × 1
search-engine × 1
google-sheets-cell-format × 1
google-sheets-arrays × 1
importfeed × 1