Hi,

I'm trying to add hyperlinks to my spreadsheet using the formula: 

But it's coming up with #NAME rather than in this example, Google. Is the way I've typed it wrong or is this an issue with Zoho Sheets?

I know you can add hyperlinks by other methods but this needs to be the way it's done so that I can automate it to add it from a different source automatically.