A function that gives you the row number of a cell as a number without using a workaround.
Sign in to see the current vote count, add your own vote, or leave a comment.
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.
I want to be able to refer to the actual row number within a given sheet, as a value in a formula. This could be by utilizing a formula like "=@row", which would use the native row number and display that value.
Many people ask for this same need to reference a Sheet's row number for a formula which already shows within the Sheet, without having to add an extra column that also auto-increments.
Yes, however if the meaning of the number is something like, "Priority", anyone viewing the sheet will not infer that from the sheet itself as the number shown by default has no column heading.
I'd like to reference a row number as text, since the row can move around, e.g., "Please see row 123 for example", where 123 changes if the row moves on the sheet. I use cell addresses in Excel for same purpose.
The "browse" button was recently changed to go through a recent workspaces menu and requiring a second click on "browse all" before actually bringing up the browse menu sidebar. This change is unintuitive as there is a "recents" button right below the browse button and for anyone who regularly uses more than 6 workspaces…
I need to be able to backup all workspaces at once. Backing up each workspace one by one is tedious and a waste of time. I know someone is going to tell me "even system admins cannot backup workspaces they are not shared to, and can only backup workspaces they own or are shared with." So, let me do that. At least let me…
Smartsheet does not currently send automated error notifications to Pivot workflow owners when workflows fail, unlike the notification behavior for DataTables, Data Shuttle, and Meshes. Also, when column mappings break on a mesh, the mesh will continue to run with an error. We should expect the same functionality from a…
