Retail

Discussion List

  • Inventory
    In Using Smartsheet
    Is 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.
    22 2
    22 views 2 comments Most recent by Andrée Starå Using Smartsheet
  • Formula Option (Similar to Google Sheets 'LOOKUP')
    In Formulas and Functions
    Hello 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…
    45 3
    45 views 3 comments Most recent by kristi_24k Formulas and Functions
  • COUNTIFS formula with year
    In Formulas and Functions
    I'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…
    432 5
    432 views 5 comments Most recent by Paul Newcome Formulas and Functions
  • SUMIF Formula - Incorrect Result?
    In Formulas and Functions
    Hello, 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…
    390 2
    390 views 2 comments Most recent by Andrée Starå Formulas and Functions
  • Use "Created By" auto generated field as a "contact list" for use with approval workflow
    In Formulas and Functions
    I 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…
    75 3
    75 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • If with dropdown list
    In Formulas and Functions
    I'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…
    124 4
    124 views 4 comments Most recent by Paul Newcome Formulas and Functions
  • SmartSheet Jira Integration
    In Archived 2016 Posts
    Hi 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…
    283 13
    Closed 283 views 13 comments Most recent by Scott Willeke Archived 2016 Posts
  • cell.format currency settings
    In API & Developers
    I'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 …
    303 3
    303 views 3 comments Most recent by Alejandra API & Developers
  • Surveying Project - How to setup the structure of Smartsheets
    In Using Smartsheet
    I 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…
    178 8
    178 views 8 comments Most recent by Andrée Starå Using Smartsheet
  • Approval flow for credit notes
    In Formulas and Functions
    Hi 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…
    23 5
    23 views 5 comments Most recent by Andrée Starå Formulas and Functions