Using Gigasheet: Functions

Change Data Type: Convert A Column
The Change Data Type function allows you to convert the data type of any column. This is helpful when you have a column that was incorrectly identified a on...
Tue, 10 May, 2022 at 5:01 PM
Convert 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, 26 May, 2022 at 11:10 AM
Cross File VLookup
Cross File VLookup allows you to cross correlate two sheets. Select the column you want to match on in the first sheet, and then select the sheet to search ...
Fri, 10 Jun, 2022 at 1:39 PM
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
Extract Day of Week
This function allows you to extract the day of the week from a date time value. For example, if you have the date time 2005-08-08 23:30:00 and apply the ext...
Thu, 26 May, 2022 at 11:15 AM
Math
The math function allows users to transform entire columns of data with arithmetic operations.  Users can raise to the power of x, add, subtract, multip...
Fri, 17 Jun, 2022 at 11:07 AM
Split Column
The Split Column function allows you to slice one column into multiple new columns based on a specified delimiter string.  Access the Split Column funct...
Thu, 26 May, 2022 at 11:17 AM