Forum Discussion
Solved
Office scripts formulas auto updating other formulas
I am currently writing an excel script that populates a table. I am trying to add a hyperlink to one of the columns; however, when I add the hyperlink via a setValue or a setFormula function, the ver...
charles983 Glad to hear that worked! You can specify the text to display like this:
table.getRange().getCell(i + 1, 3).setHyperlink({ address: "https://help.examplesite.com/tickets/" + jsonData[0][0][i]['ticket_id'], textToDisplay: "text here" })Using multiple lines isn't necessary but it does help make the code more readable.
Also, I noticed there is a textToDisplay property that can be changed. What is the syntax for adding multiple properties, similar to how you added the address.
MichelleRanMSFT
Microsoft
Microsoftcharles983 Glad to hear that worked! You can specify the text to display like this:
table.getRange().getCell(i + 1, 3).setHyperlink({
address: "https://help.examplesite.com/tickets/" + jsonData[0][0][i]['ticket_id'],
textToDisplay: "text here"
})Using multiple lines isn't necessary but it does help make the code more readable.
- Thank you, that worked great