Sales
Discussion List
-
Volunteer AllocationIn Formulas and FunctionsHi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
-
How can I create new entries/rows and make sure the link's rule applies automatically to them all?In Using SmartsheetHello All, I created a mother sheet called Product Development which we populated via it's online form. I created a secondary sheet ( daughter sheet) called Costing in which the majority of the columns are linked to the rows in the mother…
-
Column Number FunctionIn Formulas and FunctionsHi is there a function that can return the column number when given the column name? This would help when columns are added in sheets that have vlookups referencing them.
-
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…
-
Formula to Forecast Material Quantity Received vs ConsumedIn Formulas and FunctionsI am hoping there is a formula to see what I will need to forecast to purchase for material received vs consumed. Any help would be greatly appreciated!
-
How to set recurring remindersIn Using SmartsheetI have been searching through the posts and found this formula: =IF(Complete4 = 0, TODAY(), “”) using my own column names. Each time I've tried to accept the formula, I get this error message: unparseable. Am I missing some of the formula …
-
SUMIFS to Calculate Values for a Specific Year/Date RangeIn Using SmartsheetI am trying to use SUMIFS with multiple criteria, and I am failing horribly. I seem to be having trouble when I try to add the criterion to sum data from a specific year (from a Date field) and/or when I attempt to add data from a date r…
-
Conditional quantities for pricing sheet?In Formulas and FunctionsSmarties, I am creating a pricing form and am stuck on a formula. In the example, the first 4 widgets cost $10. Each additional widget is after 4 widgets is $3. In the preceding cell [1-4 WIDGETS], I have a single-select dropdown of 1, 2…Answered - Pending Review 11 views 3 comments 0 points Most recent by Mike Wilday Formulas and Functions
-
Sending out Notifications with AttachmentsIn Using SmartsheetHi there, I have set up Smartsheet so that when a Customer Order is fulfilled, the row of the Order is sent back to the Customer as an Order Confirmation. Also, we attach the Invoice for the Customer Order which should be sent back in the…
-
Multiple forms to a recordIn Using SmartsheetHi, Wanted to check if there is a mechanism wherein smartsheet can store the information collected via different forms at different points in time in a single row ? Providing an example below for more clarity - Lets say we break the cl…
