Math Column Connection

Hey Glide community!

I have a column set up for dollars spent and dollar budget. One is in the Categories sheet and one is in the Items sheet - however when I set up the Math column it only allows me to relate it to the columns in that sheet - when I need to relate it to the Items sheet > Cost [$$]

Any help and ideas are always appreciated! :slight_smile:


It’s not clear here what you are trying to do. Are you trying to subtract a value in one table from a value in another table? To do that, you’d need to first create a single relation between the two tables, and then use a lookup column to import the value you need from one table to the other.

But looking at your screenshots, it’s not immediately obvious how the two tables are related.

Perhaps if you can explain what your end goal is here?

1 Like

Hi @Darren_Murphy

Thanks so much for the response – sorry for my lack of clarity :smile:

Are you trying to subtract a value in one table from a value in another table?

Yes! From my Categories > Budget Remaining [$$] from the Items > Cost [$$] - example, if my budget is $100 and I bet $20, I would have $80 leftover

To do that, you’d need to first create a single relation between the two tables, and then use a lookup column to import the value you need from one table to the other.

I will try that out now! May need some guidance / I will be back here with I’m sure an issue or two once I try this out

The two tables are related as such

Items:
Name of Bet
Units Bet
Dollars Bet
Category (related to the Categories sheet)

Category:
Name of Sportsbook
Unit Budget
Dollar Budget
Budget Remaining (Units)
Items Total

How do I go about creating a single relation between the two tables? Not sure the process

Okay, so you’d add a Single Relation column to your Categories table, that joins the Category Name in that table to the Category Name in the Items table.
Then create a Lookup column that fetches the value you need from the Items table via that relation.
You can then use that second column in your math formula.

But your table structure still looks a little odd to me - what happens when you have multiple users, how do you know which bets apply to which users?

1 Like

Hey @Darren_Murphy so sorry I didn’t see this !!

Thanks so much for the response

But your table structure still looks a little odd to me - what happens when you have multiple users, how do you know which bets apply to which users?

This is a part that kind of puzzles me - am I able to set certain columns to be user specific? Some are greyed out but not sure if that’s because I’m not upgraded.

Basically the user would be able to add all their bets, and budgeting for units and dollars - they just cannot add or edit Sportsbooks.

Okay, so you’d add a Single Relation column to your Categories table, that joins the Category Name in that table to the Category Name in the Items table.

I will try this out now and reply shortly!

Then create a Lookup column that fetches the value you need from the Items table via that relation.
You can then use that second column in your math formula.

Will give this a go as well - lets hope I’m smart enough to figure it out :sweat_smile: