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
- 64.3K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!