Interestingly, it seems there's a Sheets add-on which provides at least some of what you want— unfortunately not with cell metadata, but rather using pairs of a

Interestingly, it seems there's a Sheets add-on which provides at least some of what you want— unfortunately not with cell metadata, but rather using pairs of adjacent cells for the quantity and units: https://workspace.google.com/marketplace/app/legendsheet/210236000731 https://workspace.google.com/marketplace/app/legendsheet/210... The dev does a demo here: https://www.youtube.com/watch?v=K6Nvw2q889Q https://www.youtube.com/watch?v=K6Nvw2q889Q