=FILENAME()
-> "C:\Users\username\Documents\[Workbook.xlsx]Sheet1"
DEFINE(
FILENAME,
LAMBDA(
[reference],
CELL(
"filename",
DEFAULT(
reference,
INDIRECT(CONCAT("A1"))))))
Help us optimize this function