You can use a Query column. The below video shows the general technique:
https://www.loom.com/share/042be3be13004355b0dedec1be67b400