However, I can not work out what the syntax would be to add multiple people in this cell. I have for example tried a number of operators without success:
Eg: Using the ADD command results in a boolen ‘true’
“AND” is a comparison operator, and cannot be used to specify multiple entries. And imagine if you would like to add 15 people automatically, that would be a mess !
To run through multiple data, you case use instead ForEach function.
In this very short example, I’ve got a people table and your Main table to auto add people in.
You’ve got to fill the option “Value for new row” with this ForEach loop that will get each people of your People Table
Just chiming in , in case you don’t use a [People Table] …
You can also simply use ListCombine() as a formula in the Value for new rows part of the People field
(This would add the concerned persons to the field while still leaving the field editable)
Hey @Catherine_Rendell. Both solutions were great, as you said this is about personal preference. In my case, like I did with excel in my former life ( ), i’m trying to avoid as much as possible to put variables inside formula, and like to have external references. So that if I have to change it later, I’ve got mastertables, rather than having to go through every formula.
, in case you don’t use a 
), i’m trying to avoid as much as possible to put variables inside formula, and like to have external references. So that if I have to change it later, I’ve got mastertables, rather than having to go through every formula.