I'm using pi datalink on excel and want to reference another cell in a expression.
For example I want the expression ('A2' = 99), where A2 is a reference to the cell A2.
Gotcha, you are trying to create the PI Expression. Give this syntax a shot:
="('" & A2 & "'=""Open"")"
It's super hard to see on my answer so I added some spacing to make it easer to read:
="(' " & A2 & " ' =" " Open " ") "
Please give that a shot
Thanks for posting on PI Square. Apologies, I'm still confused by your request.
Are you trying to construct an expression for a Datalink function using a cell reference? If I were to guess, you are trying to a performance equation to be used in a Datalink function.
If we assume that A2 is the Tag Name like sinusoid, the your cell syntax should look like: "(' " & A2 & " ' = 99)"
Again, this is all dependent on what you are after. If you can please provide some screenshots so that I understand what you are working with.
Thanks for the reply.
A2 is suppose to be a reference to the cell. So for example is cell A2 I have \\AFSRV1\Production in the cell. And I want to make an expression in another cell referring to the A2 cell. So for example ("A2" = "OPEN"), so I can use this expression in one of the pi datalink function. Hope that makes sense, sorry for the confusion.
Thanks so much!
Retrieving data ...