I would like my ‘Advance to Next Station’ Button to look at the list of numbers that are in ‘Stages Not To Skip’, find the ‘current stage’ value and then output the number that follows it into ‘Next Stage’.
Hi @Daila_Duford : How do you get your different lists of numbers in Stages to skip, Not to skip and Current stage ?
Edit : I’ve found 2 ways to do what you’re asking : Either by using Sequence() or by using Rank() . (Rank() only works if the field Current is a Number type of field though).
I had no idea how you get your lists of stages, so I improvised .
Sorry for the delayed response! Thank you so much for your help! I actually did figure it out using the Nth (+1) formula very similar to what you showed here. This is what I worked out:
(thisRow.[Stages not to skip]).Nth(Find(thisRow.[Current Stage],thisRow.[Stages not to skip])+1)
And to answer your original question, the stages are all pulled from lookup tables.
I appreciate your input so much. This community is amazing!