Forum Discussion
Solved
Want to keep same number (payrate) in a column that is hidden when inserting a row.
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...
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.
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.
https://docs.google.com/spreadsheets/d/1XH9AHJJhiHuAuINsv11o3DBIo6FHdMwv/edit?usp=sharing&ouid=109173661224374741486&rtpof=true&sd=true