Add and subtract non-numeric (and non-date) fields

Topic Labels: Formulas
Jump to Solution
3021 10
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

Hello. I need to add and subtract items that are not numbers nor dates. How can I do it?

To illustrate it, I have changing groups of people working on projects, so I have a first column for people originally assigned, then a second for people who left in the middle of the project and a third one for people assigned also in the middle:

[A] Original composition: “John” “Jack”
[B] Removed: “John”
[C] Added: “Jill”

(All above are linked to the ‘People’ table.)

I would like to have a [D] Current column where I can get “Jack” “Jill” as result of a formula, which should essentially work as D = A - B + C, i.e., D should contain items in either A or C but not B.

How can that be done, please?

10 Replies 10

Sorry for the confusion. I misinterpreted the point of your comment.