Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
how can I get via Formula the Sheet ID and the Sheet Name in the tab?
The below shown does not work. Every Sheet shall be like "SHxx Name of Sheet" (no matter if it is active or not)
Thanks in advance.
Chris
may be this
=GetActiveSheetId()&'Dashboard'
Hi Arul,
I thought of that too but when I Change the active sheet the SH-number changes too 😞
Is there a calculation for getsheetid?
Chris
Hi,
you have to use =GetActiveSheetId()
To get the Sheetid by using this one =GetActiveSheetId()
I don't think so, so you probably Need
='SH01 Dashboard'
or
SH01 Dashboard
check this it would help
If(Qvuser='ADMIN' OR Qvuser= 'SH01',0,1) apply this Condition