PowerTable
Go to websiteCommunityContact Us
  • INTRODUCTION
    • Welcome to PowerTable
  • GET STARTED
    • Prerequisites
    • Supported Data Platforms
    • Admin Setup Guide (15-day Free Trial)
  • PRODUCT TOUR
    • Explore a sample app
    • Build your first app
    • Layout & User Interface
  • CREATE TABLE APP
    • Introduction
    • Import Spreadsheet Data
    • Connect to Database
    • Enter Data Manually
    • Get Data from Semantic Model
  • WORKING WITH POWERTABLE
    • Basic Table Operations
      • Edit data
      • Bulk Edit
      • Insert rows
      • Bulk Import rows
      • Delete rows
      • Duplicate rows
      • Copy rows
      • Preview Changes
    • Explore data
      • Search and filter
      • Sort and reorder
      • Show/Hide columns
      • Pin columns
      • Column Insights
    • Conditional Formatting
  • COLUMN SETUP
    • Configure Properties
      • General
      • Lookup and Relation
      • Display
    • Upload/Download Configuration
    • Add a Column
      • Add Visual Column
        • Add Formula Column
        • Add Multi-select Relationship Column
        • Add Reference Column
      • Add Database Column
  • ACCESS CONTROL
    • Manage Access
    • Row Permissions
    • Column Permissions
  • APPROVALS
    • Set up Approval Workflow
    • User Approvals
    • Rule-based Approvals
    • Approval using a Lookup Table
    • Multi-level Approvals
    • Notify Approvers via MS Teams
    • Handling Changes Before Approval
    • Review Changes - Approval process
  • WORKFLOWS, AUTOMATION & NOTIFICATIONS
    • Workflow automation
    • Send Mail notifications
    • MS Teams notifications
    • Webhooks
    • Cascade Updates
  • Pause an Automation
  • AUDIT
    • Audit logs
  • COMMENTING & COLLABORATION
    • Commenting
    • View all comments & track changes
    • Assign users & task status
  • APPEARANCE
    • Basic formatting
    • Display Settings
  • USER MANAGEMENT & LOGS
    • PowerTable Console
    • Admin Portal
      • User Management
      • Settings
        • General Settings
        • Writeback Settings
          • Settings
          • PowerTable managed DB
  • MISCELLANEOUS
    • Keyboard Shortcuts
    • Formulas & Functions
Powered by GitBook
On this page
  1. COLUMN SETUP
  2. Add a Column
  3. Add Visual Column

Add Formula Column

PreviousAdd Visual ColumnNextAdd Multi-select Relationship Column

Last updated 1 month ago

PowerTable has a built-in formula engine that can perform calculations on your data. Formula columns are calculated columns created from your data that enable you to derive business-specific metrics or calculations on the go.

  1. To insert formula columns, go to Setup > Columns.

  1. Select Add Visual Column > Add Formula Column.

  1. Configure the formula column by entering the column name and required formula, then click Save.

The formula column has now been added successfully.

Formula columns cannot be edited directly because their values are based on an underlying formula.

To know more about formulas and functions, you can refer to

this section.
Setup > Columns
Add Formula Column
Configuring a formula column
Formula column added