I wanted to use a formula to combine these unique QTY’s across the rows. Could i use one formula that would be able to combine all these rows into a singular QTY for their unique groups? For example Kevin has two unique dates one with a combined QTY...
Not sure how to properly explain this, But i have an inventory that is transferred to excel and then updated into the FC Inventory tab daily. I want the “Current QTY” column in the FC tab, in the first pic to be automatically updated when i uploa...
Im not sure how to concisely explain this but basically i have an excel sheet thats updates QTY’s into my inventory tab (pic 4). i have a separate tab (“check” tab) that i want to automatically pull the Total Q (pic 1, inventory tab) data from my in...
IF(AND({Days Until Event}<=7, {Hours From Last Check}<-36), “yes”, IF(AND({Days Until Event}>7, {Hours From Last Check}<-71), “yes”, IF(AND({Days Until Event}>31, {Hours From Last Check}<-160), “yes”, “check”)))
Wondering if there is a quick fix to t...
Thanks for the reply, unfortunately i do have this view but due to constant movement around this table i need these QTY’s inputted into a different table, so I can run different formulas off them with a different set of views and purposes. I’m tryin...
Thank you @David_Skinner thats a step in the right direction but it rolls up the total QTYs to just the name, instead of the name/date. Many of the names will have multiple different dates and different QTY’s to each date, any suggestions?
