Two Sheets in One Report using same column

I have two sheets referenced in a report. Both sheets have column "A" which is a date column. Since Sheet #1 is the source, I would like to only pull column "A" from Sheet #1. Sheet #2 references(using formula to index match) Sheet #1's column "A" just for information.

It seems when I use only Sheet #1 in the report, I can change the date in column "A". when i use Sheet #2, it blocks revising the date in the report because it has a formula.

how can i only use Sheet #1's column "A" in order to have the capability to revise the date in the report?

Find more posts tagged with

Sheets

Reports

functionality

Cell linking

Accepted answers

Kerry St. Thomas

It sounds like you want to be able to change the date in Sheet 2's column formula, and specifically to do it inside a report. It sounds like you could create on your sheet 2 a "Manual Override" column, and then call that "A" (so it matches the Sheet 1 column name). And then somewhere on your Sheet 2, you can add your Index/Match to pull the date over, but add a clause to consider the manual override data:

=IF(ISBLANK([Manual Override]@row, INDEX/MATCH FORMULA TO PULL YOUR DATE, [Manual Override]@row)

That will make it possible for your date columns on both sheets to be manual entry. What other reports, automations, etc. you may have produced on that existing column "A" on Sheet 2 might need some retooling though.

Good luck!

All comments

Kerry St. Thomas

=IF(ISBLANK([Manual Override]@row, INDEX/MATCH FORMULA TO PULL YOUR DATE, [Manual Override]@row)

Good luck!

noshiro

HI @Kerry St. Thomas

thank you. I will try it and let you know how it goes.

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.