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

Posted on Jan 25, 2023 12:38 PM

Reply
Question marked as Top-ranking reply

Posted on Jan 25, 2023 2:29 PM

Sorry but you can not automatically sort based on the content of a cell or with a formula.


You would have to do it in two steps.

A) Set all your checkmarks

B) Select sort and the rows will be sorted based on your settings.


Alphabetize or sort table data in Numbers on Mac - Apple Support


This example will sort for the checkmark and then for the name.

No formula needed, just setup your sort rule and use it if needed.


Regards Ralf

4 replies
Question marked as Top-ranking reply

Jan 25, 2023 2:29 PM in response to MLX1

Sorry but you can not automatically sort based on the content of a cell or with a formula.


You would have to do it in two steps.

A) Set all your checkmarks

B) Select sort and the rows will be sorted based on your settings.


Alphabetize or sort table data in Numbers on Mac - Apple Support


This example will sort for the checkmark and then for the name.

No formula needed, just setup your sort rule and use it if needed.


Regards Ralf

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Is there a formula/function that will move a row if a stated condition is met?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.