Is there a formula/function that will move a row if a stated condition is met?
I am attempting to make a spreadsheet in Numbers that would function like this.
I want to be able to make a formula that when I check the box in another column in that row, the whole row will move to the bottom of the list and if unchecked it would move from the checked section to the unchecked section.
Column A is a checkbox created through the format-cell-data format drop down.
Column B is text.
Column C is the formula.
I was looking at using the 'IF' function, but this is as far as I got.
=IF(A1=true,
I'm not sure what would come after this to get the effect I want. I have the 'a1=true' part there cause when you click the checkbox the actual (that line on the very bottom of the numbers window) says true and if it is not checked it says false.
MacBook Air