i need to make an excel sheet to manage inventory, sku, inbound, outbound, production and expiry dates, batch numbers, barcodes, dimensions, volume, weight, brand, category, etc..
If you are working in Excel, you may want to search for an Excel based forum / community. This community is for Smartsheet. While they do have a lot of similarities, there are also a number of differences that could have a major impact on your solution.
ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.