Retail
Discussion List
-
Unhide SELECT ColumnsIn Using SmartsheetWhy is it that after you hide several columns, you only have the option to unhide ALL? Or am I being silly and missing something?
-
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…
-
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…
-
Trigger Outlook Calendar Event from Form SubmissionIn Apps, Integrations, and Add OnsI've created a form for my team to use to submit vacation requests with a manager approval and user alert workflow. I want to be able to have an Outlook calendar event added once the vacation request is approved by a manager. Any thoughts …
-
Combining Columns on Sheet from FormIn Formulas and FunctionsGood afternoon, I am working on an audit stock sheet, that allows a form staff can utilize for active counts and confirm physical location. With this I am trying to find the function to combine rows with the same Product Name, Product ID,…Answered - Pending Review 28 views 1 comment 0 points Most recent by Genevieve P. Formulas and Functions
-
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…
-
Forms with formulasIn Formulas and FunctionsI'd like to include a formula (hidden) in a Form that includes a vlookup to another sheet with known email addresses. This would save the user time on entering their email when completing the form. The email is used to contact them back th…
-
Calculate the time between two dates by days, hours and minutesIn Formulas and FunctionsHi, I am trying to implement the following formula from my excel spreadsheet into my smartsheet: =INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes" Basicall…
-
Time Tracking - Hours and MinutesIn Formulas and FunctionsI was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-ar…