Trying to get a formula to lookup a reference sheet to see if the ID contains the word BASE in it and return with a value SKUBASE if so and SKU if not. I feel like I'm close but just missing something. I had a formula where if I checked the box "add base" it would simply add the suffix BASE to the id however this is all…
I have the following formula that works great because I can add estimated times in until real-time data is available that is referenced to another sheet. Except sometimes I have referenced data that is really off and I want to use the estimated time until I can research the issue or until new data is put in the other…
I have several columns which I typically have a formula in nearly every row (like you would use a column formula) but I've decided to have the formula be cell based because every once in a while, I need to input a manual number instead of deriving from a formula. My current situation is that I'm using reference manager to…
你好,我一直在使用内容for several years now but really only starting to use formulas until recently so forgive my lack of knowledge. I have three sheets in play here. The primary sheet is looking at the second sheet for an average based on all references of a SKU. The second sheet might not have data for a…
I'm trying to create a notification if two cells do not match each others values. We currently would need this is a production environment where a PO quantity is created and as the item is produced, if the department doesn't log the same quantity as the PO, the notification is sent to the supervisor. For example. IF PO…
