I’m going to try to make sense of a wall I’ve been hitting for three days…I appreciate any help!
I’m working on creating a corporate budget to help a co-worker get organized.
Table 1 - Budget Categories (How much has been allocated for each category, how much has been spent, links to what receipts were spent in the category and who has spent in each category)
Table 2 - Receipts (What was spent where, links to staff that spent, and links to what category it is coming from)
Table 3 - Staff (SHOULD BE: How much of the category’s total (ALLOCATED AMOUNT field from Table 1) each person (NAMES field from Table 3) has spent (AMOUNTS field from Table 3) in percentage form displayed on Table 2)
Currently, every table links to every table. I’ve tried formulas (sums and if’s mostly), rollups, and lookups, and I haven’t found anything that works. This doesn’t seem like such an out of the box request that it wouldn’t be possible.
I’m thinking either I’m totally hitting every formula except the right one, OR I need to change some fields around for some reason.
Right now, this is totally a mock budget until I figure it out, so I’m open to a fresh start or fixing what I already have. Any ideas?
I should also probably mention that I’m on a free account for now - so no access to blocks.