Cumulative Column Query for Sheet A and Sheet B


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), " ")

Thanks & Regards


SSPM Consultants

Email ID: [email protected]

Did I answer to your question or fix the problem? Please help the Smartsheet Community by voting it Insightful/Vote Up/Awesome, or/and Accepted Answer. It will make it easy for others to discover a solution or help in answering!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!