New answers tagged

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