=GetActiveSheetId() gives Document/SH04
So i think you want to use like this
=GetActiveSheetId() = 'Document\SH02' and GetSelectedCount(Question) > 0
this makes the chart visible across all 4 sheets in my QVW. I only want it to appear on the "home" sheet.
Can you explain in detail. Its make little bit confusion.
Thanks for the reply. I think I have some other issue that is causing this problem.
So, I'll try to explain. There are 4 tabs (sheets) in this document. The conditional charts are only supposed to show up on Sheet 4. Instead, they show up on tab 2, 3 and 4 when the condition is met. this still happens even when I add the
getactivesheetid() = 'Document\SH04'
I copied Sheet 2 to make Sheet 3 & 4. Note that the box doesn't show up on Sheet 1. So, I feel like there is some condition that I created when copying the sheets that is causing or contributing to the issue. Thanks for your help.