Insert Functions

Gigasheet Support | Using Gigasheet | Help with Functions in Gigasheet, including popular functions such as Arithmetic, Explode Date, and Cross File VLookup

Arithmetic
Arithmetic: The math function allows users to create new columns of data with arithmetic operations. You can find the Arithmetic function under Tools > ...
Fri, 12 Aug, 2022 at 9:58 AM
Cleanup Unix Time
The Convert Unix Time function converts Unix timestamps or Epoch time to UTC format . You can add an offset of your choice to account for time zone variance...
Thu, 8 Sep, 2022 at 4:37 PM
Cross File VLookup
Cross File VLookup allows you to cross correlate two sheets. You’ll find this function under the Tools menu. Select the column you want to match on in the f...
Fri, 12 Aug, 2022 at 4:16 PM
Find Base64 Content
Find Base64 Content: Base64 encoding schemes are commonly used when there is a need to encode binary data. This encoding helps to ensure that the data rema...
Wed, 20 Jul, 2022 at 11:38 AM
Explode Date
The Explode Date function automatically splits date-time fields in your sheet to new columns. To use Explode Date, navigate to the Functions (Fx) menu and s...
Thu, 26 May, 2022 at 11:24 AM
Character Count
Character Count: The Character Count function does precisely what it sounds like. It creates a new column containing the (integer form) length of each stri...
Fri, 12 Aug, 2022 at 4:26 PM