Formula column that counts the number of rows. Each row having its own number

Chris Jones99

The issue I am trying to resolve is that when the sheet has 500 rows i want automation to move a number of them elsewhere. lets say i want to move everything numbered from 350- 500. so i need each row to know how many rows there are so i can add automation so over 350 move rows. the problem i am having is i cant use sequence / auto numbers. as they keep going up as rows are added and removed etc. I need the formula to work in a formula column so it just works on all new rows. please help :)

Paul Newcome

You would insert your auto-number column (called "Auto" in this example) and then use the following column formula in a text/number column:

=MATCH(Auto@row, Auto:Auto, 0)

Paul Newcome

You would insert your auto-number column (called "Auto" in this example) and then use the following column formula in a text/number column:

=MATCH(Auto@row, Auto:Auto, 0)

Chris Jones99

Wow was it that simple. no chat bot could help me get that. thank you

Paul Newcome

Happy to help. 👍️

Chris Jones99

Thank you, I don't you if you could help me with the next part. I set a automation run to move rows when the row number is above 400. However, it doesn't seem to be triggering. I guess because its looking at a formula column. any thoughts on a solution?

Paul Newcome

Can you provide a screenshot fo the automation?