Retail
Discussion List
-
Auto fill a second column based on a drop down selection using a formIn Formulas and FunctionsI understand I can likely do this with a very, very long VLOOKUP or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy. Situation: I would like to have a form where someone selects one op…
-
Smartsheet not saving consistentlyIn Using SmartsheetI have multiple Smartsheets this has happened to, although I save and make sure prior to closing the SS it has been saved, and triple-check by the "save" icon being "shaded" prior to closing the SS. From time to time wh…
-
COUNTIF Formula for Contact ColumnIn Formulas and FunctionsI have several tasks set up for team members using their email addresses in the Contact column. Some tasks have 1 member assigned and some have multiple. I have to run each person's workload and am trying to use a separate sheet that count…
-
Extract Image using Index and Match/VlookupIn Formulas and FunctionsHey All - Does this exist yet? See screenshots below. Am i missing a piece in the formula? Or is my column type incorrect? I cant seem to find an article on this. I know its a bit tricky to do this in excel too - and their version doesn't…
-
Automatically Track Inventory UsageIn Formulas and FunctionsI'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program. I'm hoping there's a way to automatically track inventory usage base…
-
Issue with leading zeroes when Identifying duplicatesIn Formulas and FunctionsI am using the following formula to identify duplicate invoice #s in a spreadsheet. I've noticed that the formula does not work when the invoice # starts with a zero. It works for all other formats: text, numbers (without leading zeroes), …
-
Resource viewIn Using SmartsheetCan I zoom out on the resource view to show the timeline by month and quarter and not just week, which is the default?
-
*NEW: Proofing using ReportsIn Using SmartsheetThe new Proofing capability is something we would like to implement in our department, but we are having issues with accessing this in Reports. We see that Proofing can be done in the main smart sheet, but our Artists access new design req…
-
Cumulative Expense Column for budget restraint checksIn Formulas and FunctionsHello I need to have a running total expense column on my smartsheet for budgetary checks. Can someone help me with a solution please? I would like a column that updates with a cumulative $ after I enter an expense amount in another exis…
-
Update Confirmation email limitationsIn Using SmartsheetHas anyone figured out a way to disable the update confirmation email that is sent following an update request? The email is confusing my user community because it links to a sheet they don't have access to. Is it possible to even change t…
