How to add lookup data to a formula result?

I have a table of notes and on my daily dashboard I want to display a bulleted list of the notes I have created today. I have figured out how to write this formula and it works. However, I also want to display the related project that is on the same row as the note. What can I add into my formula to have the Related Project show after the note itself?

Bonus question: can the Related project be a different color, to make it stand out?

Second bonus question: is there a way to have the notes Group themselves together by Related project?

Hi @Morgan_Pixley

100% possible, but could you please update your embed doc, it’ll be easier to help you :wink: