Structure - error when trying to add an effector

[JasonF]

Hey there - I have a formula that works perfectly for displaying the correct info in the column - I'm trying to write this value as an add to fixVersion and I get an error each time.  Here's the formula:

IF (targetend >= Date("2/Aug/21") AND targetend <= Date("30/Sep/21");"Ver 1";

targetend >= Date("1/Oct/21") AND targetend <= Date("30/Nov/21");"Ver 2";

targetend >= Date("4/Jan/22") AND targetend <= Date("28/Feb/22");"Ver 3";

targetend >= Date("1/Mar/22") AND targetend <= Date("1/May/22");"Ver 4";

targetend >= Date("2/May/22") AND targetend <= Date("30/Jun/22");"Ver 5";

targetend >= Date("1/Jul/22") AND targetend <= Date("31/Aug/22");"Ver 6";

targetend >= Date("1/Sep/22") AND targetend <= Date("31/Oct/22");"Ver 7";

targetend >= Date("1/Nov/22") AND targetend <= Date("30/Dec/22");"Ver 8";

targetend >= Date("3/Jan/23") AND targetend <= Date("28/Feb/23");"Ver 9";

targetend >= Date("1/Mar/23") AND targetend <= Date("28/Apr/23");"Ver 10";

targetend >= Date("1/May/23") AND targetend <= Date("30/Jun/23");"Ver 11";

targetend >= Date("3/Jul/23") AND targetend <= Date("31/Aug/23");"Ver 12";

"")

Essentially I want to be able to add an end date or due date - which would populate the version automatically, but it throws an error each time (and I've seen this before with IF statements and trying to use them in automation in structure).

So the first question is - should the above work?  The second - is there a better way of getting the information above vs a large IF statement?  Thanks!

[David Niro]

Hello @JasonF ,

David from ALM Works here.

What version of Structure are you currently using?

Best,
David

[JasonF]

Hey David - thanks for the response.  Looks like we are on version 7.4.0

Thanks!

Jason

[David Niro]

Hello @JasonF ,

Thank you!  I was having some trouble with the formula, but was trying it on an earlier version of Structure.

When I ran the Effector, it updated the Versions as expected.  I think it would be best work on this directly through our support channel. Once we identify the resolution, we can post it here for others to find.

Please contact us via support@almworks.com or our customer portal support.almworks.com.  I will be keeping an eye out for it.

Best,
David