I have below formula to show worksheet name in one of cells.

=TEXTAFTER(CELL("filename",A3),"]")

It works perfect for standalone application, however when is uploaded to sharepoint and opened from the web it displays #VALUE!

I found the below two solutions, but non of them works
= PART (CELL ("filename"; A1); FIND ("]"; CELL ("filename"; A1)) + 1; 255) = PART (CELL ("filename"; A1); FIND ("]"; CELL ("filename"; A1)) + 1; LENGTH (CELL ("filename"; A1)) - FIND ("]"; CELL ("filename"; A1)))