Return a portion of text in a CHILD cell based on Date column


I am trying to automatically pull an airport tricode out of text in a child cell (Delivery Location) based on the most recent Delivery Date. The green row is the parent. Is this possible?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!