Archives: Information

Extract current (Active) workbook name

I need that more often than I thought It is basically extract the full workbook name that we are in, with no folders, and with no extension =MID(CELL(“filename”,A1),SEARCH(“[“,CELL(“filename”,A1))+1,SEARCH(“]”,CELL(“filename”,A1))-SEARCH(“[“,CELL(“filename”,A1))-6) So, here it is….   And if we want to go 1 step further, I often have the version of the tool as part of the filename, • Read More »

CamelCase to Camel Case

Here is a good practice for combining functions to get a full smartsheet It basically add a space before any capital letter in a text, helpful when you have strings without spaces and want to convert them. It is all in formulas. Put additional spaces before any upper case letter. made specially for custom request. • Read More »

Hyperlink usage and HyperlinkOf UDF

The Hyperlink function is really powerful and yet not widely used. You can create a whole navigation system with Hyperlink fx or create a custom jump to link to take user to certain area. Of course the “Jump-to” link need other functions, like Match, Indirect and Index Here is a sample of what we can do • Read More »