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!
Answers
-
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"))
-
Hi, Thank you for your response. I tried that formula as well and I got an "Invalid Column Value" output.
-
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?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!