Formula Terminology in Stackby

Avatar

By Anjali Daga

updated about 1 month ago

Terminology


In Stackby we use formulas consisting of terms and symbols which are the same for programming languages. They are simplified to make formulas easier to write and understand.


The table below lists the terms you'll encounter and some common examples of each one.


Word 

Usage 

Example 

Curly Bracket 

Reference a {Column Name}

{Price} or {Status} 

Function   

References a formula function that performs specific calculations using specific column names 

SUM ({Value 1}, {Value 2}) or 


AVERAGE ({Value 1}, {Value 2})

Operator   

Symbols used in formula to output different calculations 

  • or  * 

String 

Group of text characters that are used in the formula. String input need to be given in double quotes. 

“This text needs to be changed” 

Array

Collection of values separated by a comma 

Price 1, Price 2, Price 3 

Integer 

Whole number - positive, negative or zero

9

Date 

A date format that can be represented in multiple ways 

January 1st, 2022 



Did this answer your question?