Cumulative Column Query for Sheet A and Sheet B

Hello,

I have Sheet A, which contains a column with work dates that have been inspected. I would like to create a cumulative column in Sheet B based on the maximum date from Sheet A. However, it appears that the current setup is cumulating all the dates in Sheet B instead of considering the maximum date from Sheet A. I have attached screenshots of Sheet A and Sheet B for your reference, along with the formula I am using.

Sheet A

Sheet B

Formula: =IF(INDEX({Sheet A Date Range 4}, MATCH([Work Date Inspected Piles]@row, {Sheet A Date Range 4}), 0) <= MAX({Sheet A Date Range Range 4}), SUMIFS(Piles:Piles, Row:Row, @cell <= Row@row), " ")

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

You'll need to use an IF statement that reads along the lines of IF the MAX({date}) is greater than or equal to [Date Column]@row, perform calculation.

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.