Creating columns that grow sequentially
I have 3 helper columns [First #] [Second #] [Third #] that are growing sequentially to support another formula I have. While the first and third column should be equal in value, the second column must be one digit higher than the other two.
I have been manually entering the sequence but I would like a formula that will calculate the sequence on its own. I tried using the Auto Number column, but that will only count for rows that have data in them, I would like this column to go on forever basically!
Thank you in advance.
Answers
-
Hey @sawuzie,
Have you considred this formula:
=1+[Second#]1
If you drag this formula over 2 rows then any addition rows will be updated with the formula automatically.
I hope that helps.
Itai Perez
Reporting and Project Manager
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
-
Thank you for you response @Itai, is there a way I can convert this a column formula so that regardless if the sheet is updated or not, the numbers will already be present?
-
Hey @sawuzie,
You dont need to convert it into a column formula.
If the formula is dragged over 2 or more rows, it will populate automatically when a new row in populated either from a form or manually.
So if I keep adding data to any column in a new row, it will automatically pull the formula down with it.
I hope that is clear.
Itai Perez
Reporting and Project Manager
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
-
Yes that makes sense, thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!