mongoSheet also provides a list of a custom functions to help you to working with data easier. There are only a few functions now, but we are looking into options to add more functions. Let consider the employee object. Suppose that you queried all the objects and you quicky wanted to pick only name from the object. You can easily do that by using the custom function PICK . Just write the function =PICK("name", B2) where the J2 is the cell that contains the father object.

Removes the key specified in the function. Let's consider the same object and you want to remove employeeId from it. Then you can write the function as =REMOVE("employeeId", B2). The result will be a new object after removing "employeeId" the original. You can also give multiple keys separated by a comma Another option is to give keys from a range

Consider a super big object or array and you need to find the number of items in it, then write the function =SIZE(B2).

If need to know all the first level keys used in the object, then write the function as =KEYS(B2)