We have a table called Documents and I want to use a formula that pulls the name of the file in the {Attachment} field in order to provide the Name of the record. I've been using the LEFT({Attachments},FIND("(",{Attachments})-1) for this purpose and ...
Thank you for the quick help! I knew it had to be something fairly simple that I was missing. I tried so many ways to combine or nest those two formulas but could never get it quite right. Your solution works perfectly.
