You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
A set of appscripts created for various purposes, mostly for Google Sheets.
GET_HYPERLINK_TEXT(cellAddress)
Add the formula =GET_HYPERLINK_TEXT("A1") - The cell address should be in quotes. You can use it this way =GET_HYPERLINK_TEXT(CONCAT("A",ROW())) to copy the formula across rows. Replace A with the correct column name.