FILTER function

Paul Newcome

Excellent! So you are up and running?

Kirstine

I am! 😆

Paul Newcome

Great!! I'm glad we finally got it working for you. 👍️

Kirstine

I mean, WE is a bit of a stretch... YOU got it working! Thank you so much! 👏

Paul Newcome

Haha. I only gave you some formulas. You are the one that put it all together. I'm happy to help.

LEllis

https://community.smartsheet.com/discussion/comment/276458#Comment_276458

Hello, thanks for posting this solution. I have a question about it.

Why do you need both the Auto and the Row column? The Row column is duplicating what's in the Auto column, so why not reference the Auto column instead?

The Auto column will only populate if there is something in that row of cells, so wouldn't the Row column just be duplicative?

Thanks!

Paul Newcome

@LEllis Using both columns ensures that the number 1 STAYS on row 1 if you decide to sort. The numbers in the Auto-Number column are locked to that row, so after sorting, inserting new rows, deleting rows those numbers could be all kinds of jumbled up.

If you are never sorting, never deleting rows, and always adding new rows at the bottom of the sheet, then you could use just the Auto-Number column.

LEllis

https://community.smartsheet.com/discussion/comment/359293#Comment_359293

That's a great point. Thanks for clarifying!

Paul Newcome

@LEllis Happy to help. 👍️