I'm looking for a formula that will help me add a value to help me categorize page type. Column 1 contains url paths and I'd like column 2 to contain either "Products" or "Content". If column A contains "/collections/" or contains "/products/" it could be classified as "Products" in column B. If neither of these are detected, then column B would be populated as "Content". Thanks for any help.
Page | Page Type |
/collections/back-packs | Products |
/faq | Content |
/collections/tents | Products |
/products/product-a | Products |
/collections/cooking | Products |
/products/product-b | Products |