Writing Formulas
Function versus Operator
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!
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.