Cell reference isn't updating

I am modifying a sheet created by a colleague. The purpose of the sheet is to provide weekly updates to a project on each row. At the top of the sheet are some hidden/locked cells and I just can't figure out what the date cell is referencing. The section auto populates current week and first and second previous week data pulled from rows updated below automatically. This info is important to me because I have it running to my dashboard. I added an update for 7/15 but noticed that 7/8 week is not updating as the previous week….any thoughts what i could be doing wrong?

Here is the formula

=IFERROR(IF($[Row
Num]@row =
"", "", INDEX($[Row
Num]$25:$[New Current Estimated Date]$179, MATCH($[Row
Num]@row, $[Row
Num]$25:$[Row Num]$179,
0),
MATCH([Status Report Date]$25, $[Row
Num]$25:$[New Current Estimated Date]$25, 0))), "")

Find more posts tagged with

Accepted answers

All comments

EvanShortreed

Good Afternoon,

Have you gone down the path of making a dynamic report scope? This will give you the ability to collect all project plans and pull the fields you need. I am also happy to hop on a call to help walk you through this.

alewisax24

Yes please, how can I connect with you?

alewisax24

I was able to research tis option, it will not fit the need.

=IFERROR(IF($[Row Num]@row = "", "", INDEX($[Row Num]$25:$[New Current Estimated Date]$179, MATCH($[Row Num]@row, $[Row Num]$25:$[Row Num]$179, 0), MATCH([Status Report Date]$25, $[Row Num]$25:$[New Current Estimated Date]$25, 0))), "")

This is the formula that was previously created for the date column but for some reason it's just not pulling the correct data now. The cells to the right of this one are also pulling information from the most recently updated row, all within the same sheet.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.