This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I was wondering if there was a way to compare data with the chart app, between tables. I have a table that is '20, '21, and will begin a '22 one shortly. I would like to compare changes from year to year via charts. Is there a way to do this? or do I...
Hi All, I am really new to formulas and I am trying to do along string IF statement. Can anyone help me identify where this is going wrong? I looked and read through other topics and just can’t get it to work. I essentially want this to go all the wa...
Hi all. I am kinda new to formulas and was hoping there was a way to make a formula that can take into account data from other tables? What I am trying to do here is assign certain data a simplified number. Example: If the number in column A from tab...
I have an inventory Base of different products (Rum, Whiskey, Tequila, Wine, etc). I want to create a table that will auto populate in-stock items when an ‘in stock/on shelf’ checkbox is clicked in the respectful table. Then remove from the table whe...
Thanks Scott. I tried lookup but all it will do is bring info from the field I select to the LookUp. What I am trying to do is create a condition that says:
If price in field ‘total net income’ is <$1000 in table aThen add #1 to field ‘total net inco...
Same. I found a thread (How to create a "fake" pivot table, with recurring records (over months)?) that goes in to dept around going around the limitations of the current block but that in itself is pretty complicated and, imo, defeats the purpose of...
