How to pull earliest start date based on condition

I am trying to create a conditional formula that will pull the earliest start date (listed on a separate sheet) based on a criteria which in this case is the room number. Currently, these dates are tied to the resource manager in the reference sheet and are manually inputted into this summary sheet

I have tried using the IF function with column references, but I feel I am missing something.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!