Forum

In W3, you typed 11-Jul-2022 as a real date, but the header in the assignments table has a text "7/11/2022". Hence, you are referencing a non existing...

Thanks for attaching the file. I've added some basic PQ code to it. See if that will work for you.

Hi Lea, I had a look at your file and note that you just dragged the formula across. Unfortunately, that doesn't work as you might expect when you ...

Probably yes, but you didn't include the file. After adding an attachment, don't forget to press the Upload button 🙂

Changed the formula so that it will except an end date based on a text entered in another cell, but I don't consider this a good solution as the "date...

See attached. Please note that I still used the columns that you mentioned earlier. Changed the header to Delivery to test the outcome.

As an alternative you could us a formula like this: =SUM(Table_assignments[[23-May-2022]:[4-Jul-2022]]*--(Table_assignments[Project Assigment]=B2))...

Hi, In C12 you can enter the following formula: =SUM(C2:C11) Is that what you wanted?

Hi James, The attached file contains a rough query that creates a raw data table, structured like the WORKAROUND table you did in Excel. Key is tha...

Correct about the duplicates. It all depends on when you refresh. If you make sure that the New table doesn't contain previously added items and if yo...

Can't really imagine how this chart was created. Can you upload the file?

Hi Justine, I suspect that you created a Bar chart. By default that puts the first series closet to the origin and works it's way up (i.e. bottom-u...

Hi Chris, Please see if you can make sense of the example in the attached file. You start with a "Base" table with three months data and load it ba...

Hi, I took a close look at your file and concluded that you violated almost every rule in the book when it comes to structuring data and writing co...

Sorry, but I'm unable to test this myself. Perhaps someone else here can help out.