Hi there,
I was asked as part of my internship to make a template with 3 shapes, which will then be used to establish process flows.
The three forms are as follows:
Capture d’écran 2022-11-21 111819.png
these forms are linked to a list of predefined services like engineering, environment, security... and when I change the service in the list, the services are automatically changed in the forms. To do this, I selected the service shape in process shape, then opening the ShapeSheet, I filled in as follows:
HideText =IF(STRSAME(Sheet.1047!Prop.PSERVICE,"Environment" ),FALSE,TRUE)


Capture d’écran 2022-11-21 113050.png
so so far everything is working fine. However, when I duplicate the shape, the formula in the HideText changes. I have :
IF(STRSAME(REF(),"Environment"),FALSE,TRUE)
And then, nothing works.
Capture d’écran 2022-11-21 113703.png
(you can see at the top left of the image the previously duplicated form and we notice that when I change service, the description of the service of the form remains blocked)
Do you have any idea how to help me? Thanks in advance!