We create many Smartsheets for clients who have Enterprise licenses (we have a Pro license). When we share a sheet with them, whether it's Editor or Admin level permissions, they only get "View Only" permissions. Is there something we or they need to do to get Editing permission?
I have some very involved nested IF(OR( formulas in my sheet. They all work past the initial IF, and the the first IF(OR( statement, then ignores everything past that one. I'm hoping it's just a syntax issue vs a limitation. Here's one example: =IF([Outsource Due Date]@row = "", IF([Route Number]@row = "FAB-WELD-NOFIN-09",…
I'm trying to figure out how to use VLOOKUP (or something else) from another sheet to lookup a "Shipped Part Number" and return all of the "Component Part Numbers" from the columns in the sheet attached. Any help would be greatly appreciated. I can make it work manually modifying the VLOOKUP by incrementing the column…
