Logic Sheet Help Center
Go to WebsiteSubmit a Ticket
  • Home
  • How to install Logic Sheet
  • 🤖Automation
    • Automation overview
    • Trigger
    • Conditions
    • Actions
      • Conditional actions
      • Update Airtable
      • Recalculate the current sheet
      • Send a Slack message
      • Send an email
      • Make HTTP request
    • Add connections
      • Slack connection
      • Airtable connection
      • Webhook
    • Merge tags
  • Utilities
    • Work with APIs
      • The LogicSheetAPI formula
    • Database connector
      • MySQL
    • Get data
    • Clean and format data
    • Calculate
    • Finance
    • Data analysis
  • Appendix
    • Supported currencies
  • Additions
    • Page 1
Powered by GitBook
On this page
  • Insert running totals
  • Insert growth rate
  1. Utilities

Calculate

PreviousClean and format dataNextFinance

Last updated 2 years ago

Insert running totals

This function will insert a column of running total values of the selected column next to it.

Column number: Type in the number of columns of the data to be processed. For example, column C should be 3.

Start row: Type in the number of the start row of the data to be processed.

This function will only process a column of data, so you have to choose which column and from which row you want the data to be processed. Here is an example:

Insert growth rate

This function will insert a column of growth rate values of the selected column next to it.

Column number: Type in the number of columns of the data to be processed. For example, column C should be 3.

Start row: Type in the number of the start row of the data to be processed.

This function will only process a column of data, so you have to choose which column and from which row you want the data to be processed. Here is an example: