subtraction

MATAYLOR

I have a column called allocate points how do I subtract number shown in in anther column

DKazatsky

In the "Points Allocated" column you shold be able to use this formula: =200 - [Points Given]@row

Andrée Starå

Hi @MATAYLOR

I hope you're well and safe!

Is the other number in one cell or the whole column?

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

MATAYLOR

Hi Andree

so this is what I have

each person has 200 points

they can give point way, and they can be given points .

I need to take way the points they give away from there total. does that make any sense. allocated point would change accordingly.

John Hamilton

I have a similar project and created a helper "calculation" sheet to do the math. I then created a row report with filters to gather the data.

DKazatsky

In the "Points Allocated" column you shold be able to use this formula: =200 - [Points Given]@row