Forum Discussion
Solved
how to reference the current sheet name in an function?
I am aware that you can reference other sheets in a function, but how do you reference the current sheet in one? IF(Current_sheet_name="user template", value_if_true, value_if_false) Thanks!
(the workbook must be saved)
If you run Excel 365:
=IF(TEXTAFTER(CELL("filename",A1),"]") = "user template", value_if_true, value_if_false)with other versions:
=IF(RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-SEARCH("]",CELL("filename",A1))) = "user template", value_if_true, value_if_false)
Here is a much more clean solution. Uses the textafter() function.
Referencing Cell C12.
=TEXTAFTER(CELL("filename",C12),"]")
There is one important issue!
If You have only one sheet in Your book, the Formula CELL("filename",C12) will return only the full path with filename, without the name of sheet. So keep in mind this case!