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.
| Name | Name | Last commit date | ||
|---|---|---|---|---|
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.