Link to a row in a different sheet based on a particular criteria

I have a Gantt Chart with information for a number of projects.

I would like to link the the task name, duration, start & finish date, % complete and status of my top 10 projects to another separate summary sheet.

I have a column Project# which identifies each project with a number i.e 1,2, 3 etc

Can I pull through all the information to my second sheet based on the project number? I don't want to copy the row as the project number may change e.g. project 1 may become 11 and project 1 be replaced by a different project. The information would then change as the project changes.

I can pull through the task name using INDEX/MATCH but I can't make this work for the duration, date, % fields. Possibly because the look up value is a number and these are dates, %s etc.

This is the MATCH/INDEX formula I have used for the task name

=INDEX({Projects 2024 Range 2}, MATCH(1, {Projects 2024 Range 1}, 0))

Can anyone help with linking the task name plus the duration, start & finish date, % complete and status info in the row using the Project# column for the criteria?

Thanks

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Have you looked into creating a row report instead?

SharonH

Yes I have that however can I link rows into a separate Gantt chart from a row report?

Paul Newcome

No, but you can apply Gantt view to the report.

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.