Hey everyone - I have two separate challenges today that I was hoping to get some help with. “Issue 1” is more important but I’m lumping these together as I just made a simple doc to demonstrate which has tables to illustrate both. Thanks in advance for any help!
1). Issue 1 - Linked in this page
- I’d like to be able to have the button listed in Table 2 adjust only the LAST row of Table 1. The way I’ve set this up, it initially seems to work and subtracts 1 from Bill’s Apples. However, pushing the button a second time then subtracts one from the whole column. Is anyone able to help me figure out the button filtering here?
- Issue 2 - Linked in this page
- In this case, I’m trying to essentially “subtract” / filter the results in table 3 according to what is displayed in table 4. I’ve seen an article here that seems to solve my problem, but I haven’t been able to make this work. I was hoping someone could help by showing the actual formulas so we could work through it in a doc I can manipulate?
- My actual source document is using values that are based on lookup columns so they come in a little differently, either as a username (@handle) or a hyperlink to the lookup table - so maybe that’s the issue?