I’m working on a Google Sheets project and need to automatically show the sheet name inside a specific cell. I want to avoid manually typing the sheet name because I have multiple sheets and sometimes rename them. Is there a built-in function or formula that can grab the current sheet’s name and display it in a cell? I’ve tried looking through the function list but haven’t found anything obvious. Any suggestions would be really helpful since I need this for creating dynamic headers in my spreadsheets.
there’s actually a sneaky trick with the CELL function - try =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) but honestly the apps script method is way cleaner and won’t randomly break like this formula sometimes does
Google Sheets doesn’t have Excel’s CELL function for grabbing sheet names, but there’s a solid workaround with Apps Script that I’ve been using for months. Go to Extensions > Apps Script and paste this: function getSheetName() { return SpreadsheetApp.getActiveSheet().getName(); }. Then just use =getSheetName() in your cell. It updates automatically when you rename the sheet, which is perfect for project tracking. There’s a tiny delay when the sheet loads, but it’s barely noticeable and totally worth it for the automation.
Google Sheets doesn’t have a direct function like Excel’s SHEET or CELL for this. The Apps Script solution works well, but here’s another approach without scripting: =REGEXEXTRACT(ADDRESS(1,1,4,TRUE),"([^!]+)"). Just heads up - this method has limitations and can be unreliable with different sheet setups. For anything serious, I’d stick with the custom function approach. It’s more stable and handles sheet renaming better. The small loading delay is worth it for the reliability.