Greetings Klipfolio Community!

The following will detail how to add a column to your table, which simply contains the row number of each entry.

This can be accomplished using a combination of the CUMULATIVE, COUNTALL, and REPEAT functions.

Lets say you have the following table;

And you wanted to add a column containing row number.

You can use the below formula to get the row number.

Please note that the parameter of the COUNTALL function is a reference to the first column.

CUMULATIVE//Add array of ones together

(
      REPEAT//Array of ones eg{1,1,1...}

     (
            1,
            COUNTALL(!Country)
      )
)

And voila!

Happy Klipping!

Joshua Cohen-Collier