You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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

Similar questions

4 replies

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

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.