I am trying to create a formula field that state if [Text Filed] = Yes then Attachment field 1, (if no)Attachment field 2 The problem is I want my result to be a pdf instead of a link. Is this possible?
There is no such thing as a formula file attachment field. The best you can do is have a formula URL field which can calculate a URL value. This page might be helpful to understand how to address file attachment URLs