Pull Items from another sheet set for earliest date

I'm fairly new to SmartSheets and have been trying to figure out how I can pull items from my master list to show what is set for the next launch.

Here is an example of my master table

I want the new sheet to capture a different row for every enhancement in the example it would grab. A,C and E.

Any help would be greatly appreciated.

Find more posts tagged with

Formulas

Accepted answers

All comments

David Tutwiler

I think a report would be more useful for this. You could point it at your master sheet and set it to sort by Target Date and even group by month so it is easier to see.

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.