Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sheet ID and Sheet Name

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

7 Replies
arulsettu
Master III
Master III

may be this

=GetActiveSheetId()&'Dashboard'

Not applicable
Author

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

Not applicable
Author

Hi,

you have to use =GetActiveSheetId()

Anonymous
Not applicable
Author

To get the Sheetid by using this one =GetActiveSheetId()

swuehl
MVP
MVP

I don't think so, so you probably Need

='SH01 Dashboard'

or

SH01 Dashboard

arulsettu
Master III
Master III

Not applicable
Author

If(Qvuser='ADMIN' OR Qvuser= 'SH01',0,1) apply this Condition