Move to next row or something after formula is run with a button click

So I have a table that is grouped by a “Status” column. I then have a button you click that will clear out the text in certain fields and change the text in the Status column. When the text is changed in the Status column it should move the record to the group with that same status. This used to work instantly when you clicked on the button. Now when you click on the button, the Status field does change, but the row stays in place and gives this message: “When you move your selection, this row will move to a new group based on current values.” Once I click anywhere outside of the row then the row will move.

I have been trying to figure out a way to add something to the formula in the button to have the row move as soon as you click the button so you don’t have to then click somewhere else before it will move. I tried adding a refresh to the formula, but that did not work.

Any suggestions or help would be appreciated.

1 Like