Support Board

Date/Time: Fri, 03 May 2024 02:04:48 +0000

Post From: Error copying formula referencing another sheet

[2021-01-08 04:00:12] Link To Thread - Link To Post [Go To First Post]
ijtraderji - Posts: 6
A related, but different issue: Say in a quote spreadsheet I have a formula like this: =IF($U3=AF$1,$S3,"") If I copy this formula to the next column, the formula correctly changes to: =IF($U3=AG$1,$S3,"") However, the copied formula continues to calculate using the value in AF1 (instead of AG1). Copying and pasting a value or otherwise putting a new value into AG1 causes it to recalculate correctly. Date Time Of Last Edit: 2021-01-08 04:01:53