This might be something totally trivial I’m missing.
I have a row with 2 number columns and a button column.
One number column is input column, the other - let’s call it lowest column - should display the lowest number of the two when the button is clicked. So effectively the button should copy the value from input column to lowest column if lowest column has higher number than input column.
So far I’ve come up with this function, but it’s not copying the right value. The actual row has more columns, and it’s taking the display column value
If( thisRow.lowest > thisRow.input, thisRow.input, thisRow.lowest )
Ideally I wouldn’t even have that button. The lowest column would update whenever input column has value lower than it has.
Any help, please?