May 11, 2017 5:32 PM
| Last Modified: May 11, 2017 5:32 PM(3786 views)
I want to fill rows with 1,2,3,4, ... I know I can use row functions, but I am practicing some simple coding.
I am writing the code below in the column formula, and it fills the rows of my Test column 1,2,3,... but last row is empty. Can anyone please point out the issue? I will eventually write script in script window, but right now just practicing in column formula...
a = N Row(); For( i = 1, i <= a, i++, Row() = i; :Test = i; );
I echo what Jim said. Column Formulas are essentially an implicit loop over all rows in the table. So, in your case, to create a column that numbers every row, the column formula for the TEST column is simply:
This will number each row of the TEST column from 1 through the end of the table.
If you were to use direct scripting from a script window: