Retail

Discussion List

  • 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…
    368 5
    368 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…
    328 2
    328 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…
    61 3
    61 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…
    113 4
    113 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…
    224 13
    Closed 224 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 …
    243 3
    243 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…
    132 8
    132 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…
    21 5
    21 views 5 comments Most recent by Andrée Starå Formulas and Functions
  • Automate RYG Balls based on 3 columns.
    In Using Smartsheet
    Hi,    I need help with finding a way to automate the RYG balls so that if no dates are input, it's white. If the first date is input, it's red. If the second date is input, its yellow. And if the final date is input, it's green.   Tha…
    41 6
    41 views 6 comments Most recent by Andrée Starå Using Smartsheet
  • Help Combining CountIFs and TODAY() function
    In Formulas and Functions
    Hello, I am having difficulty with the proper syntax in my countifs function. What I am trying to do is count the instances of a word within a specific column (this I accomplished without a hitch) and then narrow those by instances that a…
    347 1
    347 views 1 comment Most recent by Andrée Starå Formulas and Functions