Morning all.

Is it possible to create an IF argument based on the filename?

Example - A2=IF(Filename="template",A1,Filename)

Reason - A1 is the result of a MAX function on the template WB but once template is saved as a different file name I want A2 to = the new filename?

Thanks in advance for any advice given.