Is there a formula that will output the row number, and can be used in a column formula?
Looking for a formula that can output the row number, and can be used in a column formula, this mean that it can not have row specify nombre on it like [Column Name]$1 as column formula don't allow it.
Best Answer
-
Hi @Abraham Sanchez,
You need to use the Auto-Number column as a helper column and can then create a Row Number Column. I have created this for our internal users and am happy to share.
Here is a link to the sheet: https://app.smartsheet.com/b/publish?EQBCT=45339b4dd5fe4587bf818dfcd9b6cb8c
You should also be able to download the image with the instructions.
Hope this help solve your challenge!
If this answer has helped you, please Vote Up!
Jenn Hilber
Answers
-
Hi @Abraham Sanchez ,
Add a system column with autonumber. Configure it so that it represents a row number. Will that work for you?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Thanks Mark for your comment. I tried adding autonumber column, the problem is that it works initially, however if you add a row in the middel, it will give it the latest +1 autonumber, or if you delete the row, then, in both cases, it is no longer the same as the row number.
-
Hi @Abraham Sanchez,
You need to use the Auto-Number column as a helper column and can then create a Row Number Column. I have created this for our internal users and am happy to share.
Here is a link to the sheet: https://app.smartsheet.com/b/publish?EQBCT=45339b4dd5fe4587bf818dfcd9b6cb8c
You should also be able to download the image with the instructions.
Hope this help solve your challenge!
If this answer has helped you, please Vote Up!
Jenn Hilber
-
@Jenn Hilber This is AMAZING!!! thank you!!!! :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I need to update a value in a new column. How would I look at a date column that shows dates between 01/01/2025 to 03/31/2025 and place the value of Q1_2025 into another cell?
- Hi, I'm looking to write a formula using references to a rate sheet (screenshot attached with sensitive information redacted). We have several types of rates here, and also ones that are per word, whi…
- Is anyone able to help with the formula to Index Match the SO Number column and return the lowest date listed in the "finished date" column into the "first date" column? I can make it work when select…