AnnieR✭

Is there any workaround if you don't have premium?

嗨@Andree Stara ! !我希望你是好and safe too :) I don't :( ... I love pivot tables so I wish that I did but the company doesn't want to upgrade now. If I did would I be able to write formulas in the pivot table? Hope you have a fantastic week too! Annie

@Mike TV Thank you for your comment! I'm sorry that I'm late to respond. I just started pulling together a meta data sheet with quantities from all projects: Were you thinking that the QTY(Actual) columns would be the physical count number we did when we received the parts in? And then an additional count would be done…

Thanks so much!! Was I supposed to reference the entire column for "213" Qty and Part number? Edit: Nevermind, I just got it to work!!!! Thank you sooo much @Paul H !!!!!!!!

I'm sorry for my late reply @Paul Newcome !! This worked perfectly!! Thank you for teaching me too. I really appreciate it. Happy Friday and hope you have a good weekend :)

@Paul Newcome Thank you!!!! That worked! The only weird thing was it didn't work if I just copy pasted it in. I had to hand key it back in, which I thought was pretty odd. It was giving me a syntax error if I just copy pasted. If I wanted to add in a few more items for the "Purchase Order" or "Credit Card" bits. Like…

Darnit sorry @Paul Newcome I don't know how I'm mixing this up. I also need to add in to be blank if "Credit Card" is in the Part Number column but I can't even get this to work. =IF([email protected]= "RFQ", "", IF([email protected]= "Ordered", "", IF([email protected]= "Received", "☑️", IF([email protected]= "Partial", "", IF([email protected]=…

@Paul Newcome Yes! :) =IF([email protected]= "RFQ", "", IF([email protected]= "Ordered", "", IF([email protected]= "Received", "☑️", IF([email protected]= "Partial", "", IF([email protected]= "Stock", "☑️", IF([email protected]= "Ready at Vendor", "⏺️", IF([email protected]= "@ S.O. Vendor", "", IF([email protected]= "Hold", "", IF([email protected]= "Cancelled", "",…

Thank you @Paul Newcome ! Unfortunately that didn't work.

Here's another example of wrap text not working