0

I'm looking for a way to include the row number in a formula when updating multiple cells in using the Smartsheet API (Python). The goal is to create a column then put a formula that dynamically references other columns in each new cell. I have all of this worked out EXCEPT how to make the formula reference the row it is in instead of statically referencing one row. I can retrieve the rowID. But that is not useful when looping through to update cell formula.

I can do all of this manually in Smartsheet. But using the API would save me a huge amount of time.

Any suggestions on how retrieve the row#'s in a way that can be used to update cells would be appreciated.

lmarchisio
  • 1
  • 1

2 Answers2

1

Row numbers are not permanent identifiers of a row. If a row is added or deleted above a row, the row number of that row will change. The rowID will always remain the same for a given row. This is why the API uses the rowID instead of row number as the key to find information about each row.

Formulas do require row numbers. This can be retrieved from the API. rowNumber is a property of each row. See the API documentation for details.

Software2
  • 2,358
  • 1
  • 18
  • 28
  • Thank you, this makes sense. I was hoping there was a row index in the API the same way there was a column index. But i see what you're saying here. – lmarchisio May 03 '19 at 21:27
0

If your formula is referencing columns and cells across the row you can use the @row functionality in Smartsheet formulas to reference them without the row number. You can add this in the text for your formula you provide via the API and Smartsheet will reference the row as needed. More info on this is in the Smartsheet Help Center here: https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell

daveskull81
  • 627
  • 4
  • 7