How can I have a formula in the Data Pad apply to all Cells in that Column, including any future Cells?

To have a Formula apply to an entire column as Data is added to the Data Pad (with the references changing relative to the row number), simply enter the formula into Row 1 of the Data Pad:
servlet.ImageServer?id=015w0000002LSgA&oid=00D20000000HncM
When Data is subsequently added to the Data Pad, the formula will automatically be copied into the added rows, with the row references changed to the relevant row:
servlet.ImageServer?id=015w0000002LSgF&oid=00D20000000HncM