Multiple lines in cell using functions
You must already know that when you press Enter after you modify a cell, the cell content will be saved and you jump down to...
Get column name (columnname as A,B,C, etc) as input inside cell
Excel already has the formula ROW() =Row() Which as we may already know will give us the number of the row we are in, if...
Insert Blank rows into table using functions
Here you will see how to work with functions to insert a blank row every certain number of rows in a table using a blank...
Progress bar in pure functions
This one is very similar to Tally chart, however, it is for another purpose. It is used to draw a progress bar, yes a progress...
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,...