- Looking for Pivot Table Feature in Smartsheet
Hello! I'm needing to recreate this Excel Pivot table feature in Smartsheet: All I need is a summary of all part numbers. I was trying to recreate this with smartsheet summarys but I think I'm off track. I need to be able to do this in a sheet so I can use formulas so a report won't work, I don't think Any insight would be…
- Using Automations for Inventory Management
Hello! I'm struggling to come up with solutions for inventory management in Smartsheet. We order many different parts and don't really have any sort of "item master" for any cross sheet solutions that I can think of. Each project get's it's own BOM which varies quite a bit. We often order items just into inventory and then…
- 统计指数匹配横s Sheet Formula
I'm pretty instantly stumped trying to make a count index match cross sheet formula. I want a count of the Quantity column associated with those primary column part numbers. I have separate sheets for 213, 214, 215. Here's a view of the 213 sheet: Ideally it would be good to incorporate the status as well but I'm not sure…
- IF Contains Nested Formula Error
Hello! Would anybody be able to see what I'm doing wrong here? I'm trying to make it so if my "Part Number" column contains "Purchase Order" that the green icon doesn't show up. Here's my formula: =IF(Status@row = "RFQ", "", IF(Status@row = "Ordered", "", IF(Status@row = "Received", "☑️", IF(Status@row = "Partial", "",…
- If Formula Unparsable
Would anyone be able to help see what's wrong with this formula? I'm not sure how I'm screwing this up.. My formula works like this but if the status is anything other than partial I'd like the cell to say "N/A" =IF(Status@row = "Partial", QTY@row) - [Received Quantity]@row So I just tried this: =IF(Status@row = "Partial",…
- Lots of Parent/Child Relationships
Hi there, I'd really appreciate any insight you guys might have. I began setting up some parent child relationships and felt as though I nearly instantly hit a wall. We're using Smartsheet for inventory management. Let's pretend we manufacture cars and I'm purchasing every individual item needed to assemble the car. Please…
- Smartsheets for Inventory Management
Hello, We've switched over to Smartsheets right now for inventory management. Right now there's just a bunch of spreadsheets within smartsheets and we're basically doing things like we were in excel with a few added benefits. I'm researching smartsheets templates for purchase orders, tracking, inventory management etc.…
- Countif Formula while excluding items based off of another column?
Hi! I would like to have a countif formula, but I don't want smartsheets to count any items if "Hardware" is listed in a different column from my source one that I'm pulling from. Here is my formula now: =COUNTIF({Project1 _ Target Date xx/xx/xx Range 1}, Values@row) + COUNTIF({Project2 - Target Date xx/xx/xx Range 1},…
