Is there a way to have a date change in autofill within a formula?

Walter Mootz
Walter Mootz ✭✭✭✭
edited 05/06/21 in Formulas and Functions

I am looking to shift the way my data is displayed so I can place it in a dashboard. To do this, I'd like to shift the information within to do a specific date and return that. My formula works fine, but I have to change the date for every single line. Wondering if there's a shortcut or something that I could do to avoid this tedious process.

=SUMIFS({Total Time}, {Line}, "Blue", {Equipment}, "sidelasting", {Date}, DATE(2021, 4, 20))

The bolded part is what I'd like to have switch automatically to the next day in sequence through the end of this year.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!