How to Add a Person to a People Column

You have a People Column. How do you add a person or team to it?

Solution

1:{People}=ADDPEOPLE("Bob Smith", {People})

2:{People}=ADDPEOPLE("Bob Smith,Julia Marsen,Marketing Team", {People})

Explanations

The People column is a multi-value column and, because of this, the Advanced Formula Booster offers a number of special functions to interact with it. They are ADDPEOPLE, REMOVEPEOPLE, CONTAINSPEOPLE and GETPEOPLE. Please see for all details.

For our case scenario, we need to use the ADDPEOPLE function. We need to provide the name(s) of the person(s) or team(s) and the column.