Category: Standard functions

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,...

Sum of divide – Array formula

This is the answer to an old question: Here is the story behind it: I had a client who calls me every now and then...

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...