How can I auto-populate a formula in a column that is referencing values in another sheet?

jzarichney

I have the formula below that is referencing the Planned Date and Exit Shop Date, but when I drag the formula through the column it doesn't update these dates as well? What I want to do is as I drag the formula down a row I also want the Planned Date and Exit Shop Date to move down a row and not remain static

Is this possible to acheive in SmartSheet?

=IF({Planned Date} >= [Column3]$1, 0, IF({Exit Shop Date} < [Column2]$1, 0, IF(AND({Planned Date} <= [Column2]$1, {Exit Shop Date} >= [Column3]$1), {hrs per week}, IF(ABS([Column3]$1 - {Exit Shop Date}) <= 7, ({Exit Shop Date} - [Column2]$1 + 1) * {hrs per week}, ([Column3]$1 - {Planned Date}) * {hrs per week}))))

prime_nathaniel

@jzarichney you may want to reconsider your approach here, it is not best practice to drag or copy formulas in SMAR, you should whenever possible try to use a column formula instead. Also make sure you name things logically / intuitively. I can't really provide much more insight without seeing your actual sample data and a description of your intended use case (rather than the description of your issue).