Programatically changing date ranges per column

Dear all,

I created a capacity overview sheet that sums the hourly allocation of co-workers between two dates, i.e. between today() and today(7), so one week from now. I would now like to extend that functionality to between today(8) and today(14), today(15) and today(21), and so on.

Is there a smart way to do this programmatically?

Thanks in advance,

Max

Find more posts tagged with

Accepted answers

All comments

Max Gulde

For now, I solved it by adding the first row with increasing numerical values for each column WN, i.e.

=SUMIFS({Hourly Allocation Range}, {Assigned To Range}, $[Primary Column]@row, {Start Range}, <=TODAY([W0]$1 * 7 + 1), {Finish Range}, >TODAY(([W0]$1 + 1) * 7))

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.