Forum Discussion

Needsleep's avatar
Needsleep
Copper Contributor
Apr 16, 2023

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!
Excel
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    Apr 17, 2023

    Needsleep 

     

    (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)

     

tomspoors's avatar
tomspoors
Copper Contributor

Needsleep 

This worked for me:

 

=RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename")))

The right square bracket appears only once in the returned filename string.

 

Tom

colinb500's avatar
colinb500
Copper Contributor
Oct 22, 2023
I did not underetand.

Resources