Retail
Discussion List
-
InventoryIn Using SmartsheetIs there a training video to show us how to do the inventory and features? We want to use this feature but I need some training.
-
Formula Option (Similar to Google Sheets 'LOOKUP')In Formulas and FunctionsHello everyone! And thank you for your time! I'm trying to find the solution for the formula.. In Google Sheets, I used =LOOKUP(B2,OrderDetails!B:B,OrderDetails!O:O) where B2 = was order number, OrderDetails!B:B = was the range with t…
-
COUNTIFS formula with yearIn Formulas and FunctionsI'm trying to put together a COUNTIFS formula for my Sheet Summary that will count the number of items that are shown as Completed in the status column along with what year they were completed in. Looking at other discussions, I found thi…
-
SUMIF Formula - Incorrect Result?In Formulas and FunctionsHello, I was looking over the SUMIF function yesterday on this page and noticed the incorrect result for the first row example. Am i wrong or should the correct result be $2303.00? FormulaDescriptionResult =SUMIF([Price Per Unit]1:[Price…
-
Use "Created By" auto generated field as a "contact list" for use with approval workflowIn Formulas and FunctionsI have a form that is use to submit travel requests. I would like to set-up an auto-field that captures who the form was "created by", rather than having them enter their name into the "contact list". I was hoping to us…
-
If with dropdown listIn Formulas and FunctionsI'm trying to come up with the formula to dropdown only certain countries if chose certain region. I have two dropdown columns Region and Country If chose Region EMEA, country dropdown list will show DE, DK, NO If chose Region APAC, cou…
-
SmartSheet Jira IntegrationIn Archived 2016 PostsHi all, I'm new to smartsheet and have also purchased their Jira integration. I'm curious as to how many others here are using this integtation? There's a lot of quirks with the integrations so wanted to see what others thought of it…
-
cell.format currency settingsIn API & DevelopersI'm able to successfully format a cell through the API and the compact format string, cell.format (https://smartsheet-platform.github.io/api-docs/#formatting,) except for cells with currency formats. I would like to see an example of the …
-
Surveying Project - How to setup the structure of SmartsheetsIn Using SmartsheetI need to send out Architectural Survey team out to the field to survey the existing conditions of a restaurant. Information gathered is Electrical Information (Panel Size, # of Breakers), Equipment (Make Model and serial#), Condition of W…
-
Approval flow for credit notesIn Formulas and FunctionsHi all, I have set up the first draft for an approval flow to draw up credit notes. At the moment I have a flow set up as test that works very well for 1 condition - but I need to have a flow that includes 3 conditions: - credit note app…