I’ve seen questions if formulas can access other tables, and it’s a no. Workaround is that you use lookup fields and calculate with those fields from within the same table. But this very quickly clutters the table with fields from other tables, only to get them into a formula. Our tables quickly grew and got really messy.
I’d like to skip one step and directly access other tables in formulas: