Formula in button to modify list element

Hi, I’m trying to add a formula to a button so it modifies the item on a status list in the same row.

It is exactly what this example shows:

However, I can’t get it to work. It seems it’s trying to add a text element instead of bringing the element from the list.

Any help will be much appreciated.

Here’s the example:

Hello Jose! You are right, you are extracting the text from the row, so what you have to do is get the whole row, so instead of this:
Phase.Lookup(Rank,thisRow.Status.Rank +1).Status

Should be simply this:
Phase.Lookup(Rank,thisRow.Status.Rank +1)

You will notice that if you use the formula above, though it will work, it wont show the status as if you would have changed it via the dropdown, I think that is because the lookup gives you all the values that matches your criteria, in this case is only 1 but in other cases may be more. To get around that just put a .First() at the end to tell it is just one value, so the formula would end up like this:
Phase.Lookup(Rank,thisRow.Status.Rank +1).First()


Wow! That was fast, thanks a lot! It works.