Is there a way to automatically update the month formula to the next month when using drag and fill

I dragged the formulas over to May, but have to manually update the number for the month cell by cell. Example bellow.


=SUMIFS({WEEKLY FREIGHT UPLOAD Range 2}, {WEEKLY FREIGHT UPLOAD Range 1}, "Pending", {WEEKLY FREIGHT UPLOAD Range 3}, AND(IFERROR(MONTH(@cell), 0) = 4, IFERROR(YEAR(@cell), 0) = 2022))


Best Answer

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Answer ✓

    @TravisC

    There's no way to update that automatically.

    What I do when I have to use the same formula across many columns but update criteria on each one:

    Click into the formula field I want to copy, select the text for the formula, and Ctrl-C. Then I click into the cell I want to paste it into, hit Ctrl-V, and then edit the criteria. Hit enter, click into the next field, Ctrl-V again, edit & enter, click into the next column...

    As a process I find it efficient enough to get it done fairly quickly.

    Regards,

    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Answers

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Answer ✓

    @TravisC

    There's no way to update that automatically.

    What I do when I have to use the same formula across many columns but update criteria on each one:

    Click into the formula field I want to copy, select the text for the formula, and Ctrl-C. Then I click into the cell I want to paste it into, hit Ctrl-V, and then edit the criteria. Hit enter, click into the next field, Ctrl-V again, edit & enter, click into the next column...

    As a process I find it efficient enough to get it done fairly quickly.

    Regards,

    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!