How to select dynamically particular quarter column?

[AYESHASIDIKHA]

Hi,

 Expecting the solution asap.

I have so many column names starting from Q1 2022,Q2 2022,.......,Q3 2023. I wanted to use only current quarter whenever I run the workflow. Is there any tool to get the solution?

Thanks in advance!

[FinnCharlton · Accepted solution]

@AYESHASIDIKHA you can do this with the dynamic select tool and some creative formula writing:

Workflow attached, hope it helps and was asap enough for you

[Felipe_Ribeir0 · Accepted solution]

Hi @AYESHASIDIKHA 

Here is another approach, unfortunately with much more tools:

[AYESHASIDIKHA]

Thank you so much for quick solution, This actually works.

[AYESHASIDIKHA]

Thank you so much..,