Use variables in sheet actions

[shannonmarshall329]

I am trying to create a sheet action that selects the last two fiscal years using variables.  When I hard code the values it works fine, when I use variables it does not.  Has anyone used variables for sheet actions?

This way works:  ='2023;2024'

This way works: =$(vCurrentFY)

These ways do not: '$(vCurrentFY);$(vPreviousFY)' or $(vCurrentFY);$(vPreviousFY) 

[marcus_sommer]

You may try it with: ($(vCurrentFY)|$(vPreviousFY))

[shannonmarshall329]

That did not work.  It said "Error in expression" ')' expected".  I added single quotes around the entire thing and it still did not work.

[marcus_sommer]

How does the result of both variables look like in a text-box?

[shannonmarshall329]

The values return as 2024 and 2023.  However, when I put the variable in single quotes like '$(vCurrentFY)', I get the code that makes up the variable.

[brunobertels]

may be 

chr(39)&$(vCurrentFY) & chr(59)&$(vPreviousFY)&chr(39)

[shannonmarshall329]

That does not work

[shannonmarshall329 · Accepted solution]

I was able to find the solution.  The below worked.

=$(vCurrentFY) & ';' & $(vPreviousFY)

Thanks everyone for the suggestions, it helped me get to the solution.