Auto Propagating Formulas


I have two matching sheets one that captures baseline dates, the other with current projections for many (~100 milestones). I would like to generate a third sheet that has the metrics of #days difference between the baseline and current dates. I can do this using "netdays" and adding references from the two other sheets. My question: is there a way to 'drag' the formula (like in excel) to all the other cells (all three sheets are the same format) so I don't have to manually build the formula for each cell?

Best Answers

  • Lisa M
    Lisa M ✭✭✭
    Answer ✓

    Thanks so much!

    This works well for the first column but doesn't seem to be updating to reference the new columns as I drag it across. Any ideas?

    Thanks again so appreciate the help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!