Would I have to manually link each new entry in the check records tab to each new entry in the inventory tab? I’d have hundreds maybe thousands of new entries coming in and out every week so it would be inefficient if it wasn’t automated.

Can’t seem to get the formula down for updating the searched records.

I believe that’s something like I’m looking for. I’m going to have 1000+ unique inventory rows. Some of the inventories will need to be checked daily while others weekly/monthly with a formula that dynamicly upgrades their importance to daily as need...