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:
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: