How to write a link for google sheets in the parser?

Question

Python

bike_param = {
        'Название:' : bike_name,
        'URL:' : '=ГИПЕРССЫЛКА("' + url +'"; "link")',
    }

The formula is correct, but when you open the tables:


If you copy the text into a new cell, it displays as it should:

Answer 1

Try the HYPERLINK () function

bike_param = {
        'Название:' : bike_name,
        'URL:' : '=HYPERLINK("' + url +'"; "link")',
    }