In the future, can you please post a packaged workbook (.twbx) file instead? This saves helpers time, and it is easier to help you if you have a view set up in the way you intend to display your data.
Would this formula work?
See attached workbook. The methodology used will likely depend on how you intend to display this data in a viz. If it is a more complicated problem, I'd love to see a workbook that resembles what you are attempting to set up.
Exactly what I was looking for, Matthew! Thanks! (and I'll post a packaged workbook for any questions in the future)
OK, great! Note that those dates will only show up when the proper DESC is in the view, otherwise you'll see NULLs. That is why I filtered only to the Approved.