Functions

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

Calculations
Users can add, subtract, multiply, divide, or raise exponential column values by either numbers, or by another column’s values.  Note: Calculations and ...
Thu, 9 Mar, 2023 at 10:20 AM
Cross File VLookup
Cross File VLookup allows you to cross correlate two sheets. You’ll find this function under the Functions menu. Select the column you want to match on in t...
Wed, 8 Feb, 2023 at 12:25 PM
Decode Base64 Content
Decode 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 re...
Wed, 2 Nov, 2022 at 9:59 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
Explode JSON
Introduction Explode JSON functionality allows a user to correctly parse/separate a file that may have not uploaded correctly. A column may look like th...
Tue, 2 May, 2023 at 11:28 AM
Formulas
Introduction Users can create new columns in Gigasheet using spreadsheet-like formulas. Note: Gigasheet formulas are different from formulas in a typic...
Wed, 31 May, 2023 at 6:36 AM