I am making a detail stamp. it is made from a note that has links to custom properties. i want to grab the file name, and only use the last two digits as the detail number. is there a way i can do this. can i use an Excel formula inside a note?
Nopes you can have excel formula in note. But you can try that in the custom property or add a macro in the property to get the last two digits from you description and then link the note to that custom property. Alternately you can add last digits as a separate property