Comparing two lookup columns

[Eden]

@Eden

last submitted phase per opening, based on the last submitted record for this opening

So I came across this answer by @Jeff_Hager,

Lookup Latest Row (idea for lookups with Multiple Relations)

This is multiple steps, but you can do a rollup on your relation to get a max date for example, build a template with the rollup date and whatever you used for your previous relation in the sheet containing the relation and The sheet you are relating to. Then create a new single relation using the template to get only the last record. It’s a lot of Glide columns, but it’s better than a completely separate sheet and duplicated data.

so that resolves the question of getting the last phase submitted. As for the upcoming phase, I can do without it. Thank you Jeff