Dynamic Select Tool - If formula to select fields based on condition

[anwerm2]

Hello - I need help in writing a conditional formula in Dynamic select tool. I want to use and keep one workflow to use two different version of tabs new version and old version. So in the Dynamic Select tool I am trying to write this formula but it is not working. The tab name is same for old and new.

IF [Name]="Capex" THEN [FieldNumber] in (1,2,3)
ELSE
[FieldNumber] in (8,9,10)
ENDIF

New version of tab

F1	F2	F3	F4	F5	F6	Capex	F8	F9	F10
Jan	Q1 Total	Feb	Mar	Apr	Q2 Total	May	Jun	Jul	Q3 Total

Old version of tab

F1	F2	F3	F4	F5	F6	F7	F8	F9	F10
Jan	Q1 Total	Feb	Mar	Apr	Q2 Total	May	Jun	Jul	Q3 Total

So what I am trying to do here is when I run workflow it should go and check if column "Capex" is exist then select 1,2,3 columns ELSE select 8,9,10 columns

I am most interested to use some formula in Dynamic Select Tool instead of using Transpose Tool.

Thank you in advance.

[Bennel_Wilson]

Hi,

I tried multiple ways of doing it and each time the reverse of the formula seemed to be working. I found it strange too.

IF [Name]="Capex" THEN [FieldNumber] in (8,9,10)
ELSE
[FieldNumber] in (1,2,3)
ENDIF

Output:

Strange!! But it works 😛

Regards

Benn
 

[DavidP · Accepted solution]

The formula in dynamic select doesn't work exactly like you'd expect.

This is how I would do it. It works for both scenarios. 

[anwerm2]

Fantastic David - it is working fine. Thanks a lot for your help