Inventory List with Reorder Highlighting Template Error

%3CLINGO-SUB%20id%3D%22lingo-sub-1725816%22%20slang%3D%22en-US%22%3EInventory%20List%20with%20Reorder%20Highlighting%20Template%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1725816%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20am%20using%20the%20online%20Excel%20template%20titled%20%22Inventory%20list%20with%20reorder%20highlighting.%22%20I've%20customized%20it%20by%20renaming%2C%20reordering%20and%20adding%20columns%2C%20and%20as%20a%20result%20the%20automatic%20highlighting%20feature%20is%20no%20longer%20working.%20This%20feature%20is%20designed%20to%20analyze%20three%20columns%20in%20the%20worksheet%20(%22Quantity%20in%20Stock%2C%22%20%22Reorder%20Level%2C%22%20and%20%22Discontinued%3F%22)%20and%20highlight%20the%20row%20if%20the%20%22quantity%20in%20stock%22%20number%20is%20less%20than%20the%20%22reorder%20level%22%20number.%20It%20will%20also%20add%20a%20flag%20at%20the%20far%20left%20side%20of%20the%20spreadsheet.%20The%20formula%20for%26nbsp%3Bhighlighting%26nbsp%3Breads%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIFERROR((%5B%40%5BQuantity%20in%20Stock%5D%5D%26lt%3B%3D%5B%40%5BReorder%20Level%5D%5D)*(%5B%40%5BDiscontinued%3F%5D%5D%3D%22%22)*valHighlight%2C0)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20to%20reassign%20the%20formula%20to%20the%20relocated%20cells%20but%20I%20can't%20get%20it%20to%20work.%20You%20can%20see%20the%20attached%20spreadsheets%20of%20the%20template%20and%20my%20edited%20sheet%20for%20reference.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1725816%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hello,

I am using the online Excel template titled "Inventory list with reorder highlighting." I've customized it by renaming, reordering and adding columns, and as a result the automatic highlighting feature is no longer working. This feature is designed to analyze three columns in the worksheet ("Quantity in Stock," "Reorder Level," and "Discontinued?") and highlight the row if the "quantity in stock" number is less than the "reorder level" number. It will also add a flag at the far left side of the spreadsheet. The formula for highlighting reads:

 

=IFERROR(([@[Quantity in Stock]]<=[@[Reorder Level]])*([@[Discontinued?]]="")*valHighlight,0)

 

I've tried to reassign the formula to the relocated cells but I can't get it to work. You can see the attached spreadsheets of the template and my edited sheet for reference.

 

0 Replies