Community!
Thanks for all the great ideas I find here. You guys are really awesome.
In a previous thread, I got some ideas of modifying the expression in a multi row formula tool:
IF !isnull([End date])
then 'Achieved'
elseif [Row-1:Milestones]='Achieved'
then 'Next'
else 'Future'
endif
I need add additional states to the expression. If the first phase of testing is in the future, it should not be called Future but Next, then when the last phase of testing is complete (has an end date) it should be moved to a new category called Post Completion.
Please reference the attached simple sample.
Thanks!
Thread from previous conversation.
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/identifying-the-next-gateway-in-line-based-on-dates/m-p/496206#M101739
