-
if statement
Hello, I am trying to make an "if statement" but I got no luck. I don't know how to start, I tried with =IF(sqf1 > "32", "width1*hight1*5.5", "sqf1 < "32""width1*hight1*8.5") I know its looks bad :D Thank you
-
Assembly + Inventory Tracking
I've created a smartsheet to track every unit we sell of one of our particular product lines. The sheet includes the unit's serial number, model number, client name, client PO number, internal 'project number', current location of unit (Ex: "On order", "Johnny's bench", "Software dept.", "Warehouse", "Shipped - En Route",…
-
Using smartsheet to survey clients (net promoter score)
i'm looking at whether to use survey monkey or smartsheet for a client survey. I'd like to be doing regular surveys so am thinking smartsheet. Has anyone used it for this purpose? What should I know before I start? Is it better than survey monkey? Thanks
-
Export to Database
Hi, I wish to store the data on my smartsheet to a local SQL database. How do I go about doing this? We need this to create metrics that can track time taken for approvals etc.
-
Inventory checklist
I have to create an inventory checklit based on an Excel document I will have 2 main sheets: Inventory & Picks Inventory will have a list of all the SKU/units that we have per product. Picks will need to offer me the option to select one item from the Inventory sheet and once I pick it, it has to tell me if we have enough…
-
Unable to access specific sheets
Hello, Has anyone lost access to a sheet due to a generic Ajax error and had it successfully fixed? We have a Enterprise account with hundreds of users, yet none of us are receiving timely communication or any resolution plan from Smartsheet support. Have any of you run into this before? I am very concerned we are going to…
-
Locate/Find COUNTIFS
e.g. =COUNTIFS(Recruiter:Recruiter, "Christie", [Deal Date]:[Deal Date], MONTH(@cell) = 10) e.g. = 50 This is an example of how I identify my "deals" for the month in a sheet which lists every deal my company has made. The sheet contains thousands of lines. Is there a way to search/locate/find or highlight these 50 deals?…
-
Notifications and other communication not working
Dear Smartsheet, I had a short presentation of Smasrtsheet functionality and I have faced huge problem with notifications. I have a couple of sheets where all notifications are not sent for some reason. I am trying to play with fields that are triggering these notifications and none of them are working. I have checked if I…
-
Cell Linking for Updates?
I'm trying to find a solution to reduce the number of updates my team and I have to do. We currently use Smartsheet to create and manage project plans but also have a master "Status Sheet" that lists all projects, their current task, and the deadline of this task. Whenever we update the project plan, we also have to update…