Vlookup or Index in a date column

I have read all the comments relating to the above, but nothing works for me. So I had to Link a cell, which means that if a row or column is added, I will have to amend the link.

I just wanted my Start date in a Gantt at Task@row to be able to look for this Task@row in another Gantt sheet and come back with the corresponding date. The function itself seems not to appear in the initial Date Column, when I "force" it, then there is no option to link an other sheet reference.

Please if you know for sure, could you let me know (how or impossible :))

Many thanks

Find more posts tagged with

Accepted answers

All comments

Mike TV

@KarineMul22_TPg

Use an absolute reference so if a row is moved it will still know where to look.

https://help.smartsheet.com/articles/2476816-create-cell-column-reference-formula

It's explained on the 3rd row of the chart on the link above.

Genevieve P.

Hi @KarineMul22_TPg

As long as the Task@row is unique across both sheets, you can use an INDEX(MATCH formula combination for this!

=INDEX({Column with Date to return}, MATCH(Task@row, {Column with Task in other sheet}, 0))

However keep in mind that if you're using Dependencies in your sheet you won't be able to put a formula in a Start or Finish date column (see: Areas where formula use is restricted)

Cheers,

Genevieve

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.