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

Beth C
Beth C ✭✭✭

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?

Screen Shot 2022-03-20 at 11.09.49 AM.png


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!