Community Knowledge Base Product Roadmap Full Course Catalog
Basics of Formula Writing

Basics of Formula Writing

Look into the essentials of crafting basic formulas in Pigment and lay a solid foundation, comparing and contrasting the syntax of Pigment formulas with that of Excel, to ensure a smooth transition for those familiar with spreadsheet environments.

rate limit

Code not recognized.

About this course

Look into the essentials of crafting basic formulas in Pigment, a key skill set for efficient data analysis and reporting. This module is designed to lay a solid foundation, comparing and contrasting the syntax of Pigment formulas with that of Excel, to ensure a smooth transition for those familiar with spreadsheet environments. 

Who should take this course?

This course is designed for technical users. 

Elevate your technical expertise with a focused exploration of Pigment’s formula syntax, understanding how to reference objects, items, and properties effectively. This module will enhance your ability to perform basic operations, use parentheses and square brackets correctly, and tailor your data manipulation efforts with precision.

Topics Covered

  • Transitioning from Excel to Pigment: A syntactical comparison.
  • Basis of Pigment formula syntax.
  • Navigating the use of different brackets for accurate formula construction.
  • Practical applications: Performing basic calculations and data manipulations.

Content Type

  • On-Demand

Course Duration

About 40 minutes

About this course

Look into the essentials of crafting basic formulas in Pigment, a key skill set for efficient data analysis and reporting. This module is designed to lay a solid foundation, comparing and contrasting the syntax of Pigment formulas with that of Excel, to ensure a smooth transition for those familiar with spreadsheet environments. 

Who should take this course?

This course is designed for technical users. 

Elevate your technical expertise with a focused exploration of Pigment’s formula syntax, understanding how to reference objects, items, and properties effectively. This module will enhance your ability to perform basic operations, use parentheses and square brackets correctly, and tailor your data manipulation efforts with precision.

Topics Covered

  • Transitioning from Excel to Pigment: A syntactical comparison.
  • Basis of Pigment formula syntax.
  • Navigating the use of different brackets for accurate formula construction.
  • Practical applications: Performing basic calculations and data manipulations.

Content Type

  • On-Demand

Course Duration

About 40 minutes