Want to keep same number (payrate) in a column that is hidden when inserting a row.

[tommy1292]

I want to keep same number (payrate) in a column that is hidden when inserting a row. I already have a table applied. The formula is automatically in the new row but when I enter data for the formula to calculate it does not compute because the payrate did not drag down.

[#2]

@tommy1292 

Enter the pay rate as a formula. For example, if it is 15, enter =15 in the pay rate column in the first row.

It should automatically propagate to existing and new rows.

[#3]

does not work. just tried

[#4]

@tommy1292 

It works for me - I tested it.

Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.

[#5]

https://docs.google.com/spreadsheets/d/1XH9AHJJhiHuAuINsv11o3DBIo6FHdMwv/edit?usp=sharing&ouid=10917...

[#6]

Column D, G, and J are hidden and thats where I need the same number (payrate) to automatically fill as I insert new row for the fomula.

[#7 · Accepted solution]

@tommy1292 The cause of your problem is the inconsistent table setup: you used the first data row as header row. That prevents formulas from being copied automatically.

I moved the headers to the header row, and redid all the formulas. It now works correctly for me.

See the attached version.

[#8]

Ah!! Thank you so much!! Life saver