Return MIN date from another sheet if criteria are met

Sam Swain
✭✭✭✭
Hello community!
I am trying to return a date value from another sheet if criteria are met.
TIME SHEET
The date on the first row uses this formula:
=DATEONLY(MIN({StartDate})) + ""
It is pulling this information from the PROJECT PLAN SHEET start date column:
I need the formula in the highlighted cell of the TIME SHEET to return the MIN date from the 'Start Date' column in PROJECT PLAN SHEET if it is part of the feasibility section.
Is it a combination of DATEONLY(MIN for the date and also INDEX(MATCH for the word "Feasibility"?
THANK YOU IN ADVANCE!
Regards,
Sam
Answers
-
SOLUTION
=INDEX({StartDate}, MATCH(Project@row, {Item}, 0)) + ""
Then change column type to date to avoid formula returning the hour and minute.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!