Kuovonne's Guide to Airtable
Share
Explore
Kuovonne's Guide to Airtable
Writing Formulas

Function versus Operator

Thank Kuovonne for creating this content!

CONCATENATE() versus &

Use CONCATENATE() when one of the elements to join is a multi-line element.
Use CONCATENATE() to join several elements to avoid a long line.
Use & to join short related items, such as the label for a field value, units for a number, or a delimiter.

SUM() versus +

Use SUM() when one of the elements is a function or multi-line element.
Use SUM() to add several elements to avoid a long line.
Use + to join short items.
Thank Kuovonne for creating this content!

Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.