Adding to the conversation as this left me scratching my head a bit as well :slightly_smiling_face:
In my case, I wanted a Formula field to pull in values from adjacent fields (within the same table). Basically: “This Field X needs a value. Get thi...