How to insert a function into a link?

D

Dmitry2021-06-30 12:37:41

Google Sheets

Dmitry, 2021-06-30 12:37:41

Tell me, please, there is a link to a sheet in google sheets 'Sheet1'!A1, and there is a function =sheetName() that returns the name of the sheet, how can I insert this function that it was like this 'sheetName()'!A1 ?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Alexander Ivanov, 2021-06-30
@oshliaer

Maybe,
=INDIRECT(sheetName() & "!A1")

Similar questions

S

sergei1792021-02-24 18:12:35

How to write a plus sign before text in google sheets? 1Reply

V

Vladimir Kalaganov2019-07-26 14:50:44

Checking links in Google sheets (link checker google sheets), How to do? 1Reply

A

Alexander Andreev2017-03-14 13:55:37

How to get the contents of a sheet/tab of a table on google docs? 0Reply

P

PiShim2021-03-09 12:16:37

How to make a script to select the entire line GOOGLE SHEETS? 1Reply

I

indevor2015-03-13 12:12:11

Booking system (reservation) of goods (orders) Google spread sheet. Examples? 1Reply

Didn't find what you were looking for?

Ask your question