or Explore Discussions

# 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