A function that gives you the row number of a cell as a number without using a workaround.
Yes. I can see the need for this in a few of my automations/formulas.
This would be great for making conditional formatting for highlighting alternate rows or alternating groups of rows.
I strongly support this enhancement. Also wanted to put the workaround out there for anyone looking for it.
Using the auto number column you can achieve this.
lets say the auto number column is named AutoNumber, and the row number column is named Row
In your helper column you would put =MATCH(AutoNumber@row, AutoNumber:AutoNumber, 0), and make it a column formula.
This would give you the row number at all times after you save.
Hi Community, Welcome to the Product Feedback and Ideas space where you can help shape the future of Smartsheet! We really appreciate your feedback and will take all posts into consideration. Our product team will review top ideas and requests monthly and we'll share updates as soon as we get them. Remember: if you have a…
Hi! It would be great if sheet admins could overwrite what's in an auto number column in the event we ever need to assign something a specific # or ID.
I'm working on a program tracker that includes revenue forecasting in each month. Project durations can range from one week to six months or more and I want the revenue to be forecasted evenly over the duration of the project. A date formula that calculates the number of days in a specific month between two dates would be…
I really think it would make things better if I could easily expand and collapse all on the mobile app. It's too much to scroll through on a small screen, and also very time consuming to manually collapse each parent. Especially when it needs 2-5 seconds to save after each change. Please add this feature. I' very fond of…
©2024. All Rights Reserved Smartsheet Inc.