topic Re: Use variables in sheet actions in App Development

Use variables in sheet actions

shannonmarshall329 — Wed, 28 Aug 2024 14:27:57 GMT

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)

Re: Use variables in sheet actions

marcus_sommer — Wed, 28 Aug 2024 14:49:08 GMT

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

Re: Use variables in sheet actions

shannonmarshall329 — Wed, 28 Aug 2024 14:53:14 GMT

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

Re: Use variables in sheet actions

marcus_sommer — Wed, 28 Aug 2024 15:10:01 GMT

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

Re: Use variables in sheet actions

shannonmarshall329 — Wed, 28 Aug 2024 15:32:57 GMT

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.

Re: Use variables in sheet actions

brunobertels — Wed, 28 Aug 2024 15:38:44 GMT

may be

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

Re: Use variables in sheet actions

shannonmarshall329 — Wed, 28 Aug 2024 15:42:03 GMT

That does not work

Re: Use variables in sheet actions

shannonmarshall329 — Wed, 28 Aug 2024 18:20:21 GMT

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

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

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