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

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.

Find more posts tagged with

Manufacturing

Sheets

Calendar View

Automations

Cell linking

Accepted answers

Walter Mootz

Figured this out myself. Created a dat column and referenced it in the formula with @row instead.

All comments

Andrée Starå

Hi @Walter Mootz

I hope you're well and safe!

You could use the TODAY function.

Would that work/help?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Walter Mootz

i want the specific date that's in the sheet, for example, 4-20-21. I do not want today's date as that would only give me the information from now instead of the history i'm trying to display in my dashboard.

Walter Mootz

Figured this out myself. Created a dat column and referenced it in the formula with @row instead.

Andrée Starå

@Walter Mootz

Ah, I see.

Glad you got it working!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.