Help with INDEX/COLLECT with a MAX/COLLECT

I am attempting to create a few reference columns using an INDEX/COLLECT function and incorporating a MAX/COLLECT because there is a 1-Many relationship on the RTO Queue ID in the 2nd sheet so I would like to use the row with the MAX Fully Executed Date. Below is the formula I am using:

=INDEX(COLLECT({IA Assigned}, {RTO Queue ID}, [RTO Queue ID]@row, {Fully Executed Date}, MAX(COLLECT({Fully Executed Date}, {RTO Queue ID}, [RTO Queue ID]@row))), 1)

This is working, except it doesn't take into account when Fully Executed Date is blank. How can I incorporate the data when the Fully Executed Date is blank?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!