How GAS Determines if a Hyperlink is Configured for a Specific Cell Value in a Spreadsheet

Asked 1 years ago, Updated 1 years ago, 442 views

For example, there is data that contains a string in column A.
If the link is set halfway as shown in the image,
I would like to set up a script to set up hyperlinks only for strings with no links.

I've looked into various things, but I don't know how to determine if the link is set.
Please let me know if anyone knows.

数字 The numbers are appropriate.

Enter a description of the image here

google-apps-script google-spreadsheet

2023-01-19 07:51

1 Answers

I don't think it's an ideal solution, but I think the code on this site will help you with the link decision part.
[Useful with GAS] Extract all links in the sheet


2023-01-19 13:49

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.