Pulling in earliest start date from another sheet based on one criteria

Hi Smartsheets Community,

I am trying to work on a formula that pulls in the earliest start date for a column (in another reference sheet) based on a criteria, which is the project type.

The current formula I have is:

=MIN(COLLECT([{Additional Items Target Start Date}]:[{Additional Items Target Start Date}], [{Additional Items Project Type}]:[{Additional Items Project Type}]), "Strategic Talent Initiatives - Mobility"))

I am trying to pull in the earliest start date from all projects that have their project type labeled as "Strategic Talent Initiatives - Mobility" but keep getting errors.

Thank you for your help!

Find more posts tagged with

Accepted answers

All comments

Nic Larsen

Since its a cross sheet, I think this would be closer

=MIN(COLLECT({Additional Items Target Start Date}, {Additional Items Project Type}, "Strategic Talent Initiatives - Mobility"))

shuang

https://community.smartsheet.com/discussion/comment/452965#Comment_452965

Hi, Thank you for your response. I tried that formula as well and I got an "Invalid Column Value" output.

Nic Larsen

Is your date column formatted as a date column? And the column in your sheet where the formula is, is it also a date column type?

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.