Sales
Discussion List
-
Subtract list of items from InventoryIn Using SmartsheetHi, I have a Inventory Sheet with list of items and also the quantity of each item. I also have products that use various items from the Inventory list, for example: Product #1 = 2 screws, 1 sign, and 2 hooks. And the way I have set it up …
-
Highest value on the last six values of dataIn Formulas and FunctionsI'm looking to find a formula that will capture the last six months of data and then return the highest value within those six values. On excel, I've used, for example, MAX(OFFSET(B3,COUNTA(B3:B113)-6,0,6,1)) but I see "offset" i…Answered - Pending Review 77 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
How to have a report exclude certain itemsIn Using SmartsheetHi, I'm trying to build an action item report that only shows approved items that do not meet certain criteria. So in the smartsheet, there is a check box for a document attached and several columns for links to other places. I would like…Answered - Pending Review 265 views 12 comments 0 points Most recent by Andrée Starå Using Smartsheet
-
Value in one sheet create a "populate" trigger in another sheetIn Using SmartsheetGood afternoon We have a bid invite sheet that we fill out with prospective jobs (each row is a prospective job) to bid on. It has multiple columns of Data that if we decide to bid on the job would need to be transferred to our sales/esti…
-
Forms with WorkflowIn Formulas and FunctionsHi, Is it possible to creare forms with workflow e.g if I click "fruits" I will se options "Apples, Oranges..." If I click "Veg" I will se options "Tomato, Onion..." I would like to create Sales tool…
-
FORMULA NOT WORKINGIn Formulas and FunctionsHI, I have a formula =IF(E3>0,E3-C3,TODAY()-C3) this works great in excel but in smartsheet it comes back with #INVALID COLUMN VALUE can anyone help fix this issue?? Please see attached excel with formula in Column D Thank you …
-
How do I track incoming emails in a Smartsheet?In Using SmartsheetWe are getting slammed with inquiries to our [email protected] gmail address. I think there's a way to send all those emails to a Smartsheet so I can assign, triage, and track our responses.Answered - Pending Review 292 views 3 comments 0 points Most recent by Andrée Starå Using Smartsheet
-
Index/Match? Not sure best function for my needsIn Formulas and FunctionsHello, I have a very extensive sales tracker that I use to log charges and calculate the sales rep's commissions based on those charges. The commission percentages change depending on a variety of scenarios, so I created four columns with …Answered - Pending Review 33 views 2 comments 0 points Most recent by Annie Dunn Formulas and Functions
-
Track time an item was open (active)In Using SmartsheetI have a date stamp column already in the SmartSheet. When a new row is added, a date and time are assigned. What would be the best method of tracking and reporting the time duration between when the row was added and when it was closed ? …
-
Dashboard reading data from same sellIn Using SmartsheetI want to be able to display the data from the same cell in a sheet within the dashboard The sheet is updated using forms which put new data on the top row, but the value of the cell I had selected in the top row (now the second row) rema…