Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi, maybe this can help you to check the ID of the Sheet:
Subfield(GetActiveSheetId(), '\', 2)='SH01'
Hi, maybe this can help you to check the ID of the Sheet:
Subfield(GetActiveSheetId(), '\', 2)='SH01'
Which condition you are using?
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
Please try below syntax -
=If(GetActiveSheetId()='Document\SH01','Text Message)
Let me know if it resolves your query.
--
Regards,
Prashant P Baste
Jemimah! You are right. Now I changed my thoughts but My question was all about getactivatedsheet() function. earlier I do not know about this