Sheet ID literal help needed?

[#1]

Hi,

I wanna conditionally display text when Sheet ID = SH01. QV is throwing error that Sheet ID is not a valid literal can you please help to achieve this functionality?

[rubenmarin · Accepted solution]

Hi, maybe this can help you to check the ID of the Sheet:

Subfield(GetActiveSheetId(), '\', 2)='SH01'

[Kushal_Chawda]

Which condition you are using?

[#4]

Hi,

Objects are specific to sheets.So if we are viewing 1 sheet(which has a particular sheet ID),objects for that sheet will be visible.So why do we require to define a condition to view a txt based on sheet ID.

Please explain your requirement if I am wrong

Regards,

Jemimah

[prashantbaste]

Please try below syntax -

=If(GetActiveSheetId()='Document\SH01','Text Message)

Let me know if it resolves your query.

--

Regards,

Prashant P Baste

[#6]

Jemimah! You are right. Now I changed my thoughts but My question was all about getactivatedsheet() function. earlier I do not know about this