IF THEN using multiple sheets and multiple columns

I am looking for a formula that brings over data from a column only if there is a date in another column.

=IFERROR({Dallas Tracker NEW Start Date} > 1, (IFERROR(INDEX({Dallas Tracker NEW Mileage}, MATCH([SEGMENT ID]525, {Dallas Tracker SEGMENT ID}, 0)), "")))

So basically if there is a start date in a specific column, I want to know what the mileage is in a different column. My problem with this formula is that it pulls over mileage from other columns that share the same SEGMENT ID if that data was listed first.

I know the first part of my formula has to be wrong. I just don't know where to begin with this one.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!