Retail
Discussion List
-
Quickbooks & SmartsheetIn API & DevelopersSo. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use. It has many application & the proof of concept exists and we use it. We use it for an approval process (for in…
-
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…
-
VLOOKUP to another sheet using imagesIn Formulas and FunctionsI love the new VLOOKUP functionality and am using it to try to reference IMAGES that I have stored in another sheet.However, I noticed that SmartSheet only pulls in the image name (example: imagename.jpg) and does not actually show the ima…
-
CTRL + ] Does Not Indent, But Right Clicking DoesIn Using SmartsheetOur Senior VP is having an issue with a sheet where she is unable to indent a row to be a child/sub-task. The strange thing is she is able to right click and indent it, but not using the keyboard shortcut. The keys are working just fine (…
-
With a Dependency enabled, how to create Start dates for specific days of the weekIn Using SmartsheetI have a building project where tasks cannot begin until an item has arrived from a supplier, then the dependent task can only be carried out on specific days of the week, e.g. a wall cannot be painted until the paint arrives, and the task…
-
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), …
-
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…
-
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?
