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