Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
Dragging down date formulas
I am trying to drag down dates to populate year days using formulas. It does not go to the next day using drag down. Is there any trick to it? Here is the example
First Cell =$Date$1 - VALUE(YEARDAY($Date$1) - 1) = 01/01/2020
Second Cell =$Date$1 - VALUE(YEARDAY($Date$1) - 2) = 01/02/2020
Third Cell =$Date$1 - VALUE(YEARDAY($Date$1) - 3) = ......