0

I would like to get Google Sheet's URL automatically when there is a specific no. in row A and a sheet name provided as prerequisites.

If there is 15106 in row A and a sheet name --> See this

I would like to display it somewhere on the same line with the number.

Nayantara Jeyaraj
  • 2,624
  • 7
  • 34
  • 63
Hisaki Tokushima
  • 25
  • 1
  • 5

1 Answers1

0

You can try writing an onEdit() function that gets the URL when the sheet is edited - you can tell the function to look for specific ranges and values as you desire. You will have to assemble the url yourself using spreadsheet ID, which you can get using SpreadsheetApp.getActiveSpreadsheet().getId(). See Google's guide to triggers for more information on onEdit().

Tiffany G. Wilson
  • 573
  • 3
  • 11