Sheets

Discussion List

  • How to use index/match on multiselect dropdown list?
    In Formulas and Functions
    I am working on launching a global hiring form that uses this formula: =IFERROR(IF([email protected] = INDEX({Approved Seats Country}, MATCH([Unique Seat Code]@row, {Approved Seats Unique Seat Code}, 0)), 0, 1), 2) Basically this formula returns…
    Answered - Pending Review
    48 1
    Answered - Pending Review 48 views 1 comment Most recent by Leibel Shuchat Formulas and Functions
  • Time Indication and DATEONLY function
    In Formulas and Functions
    Hello, I have a few questions below regarding Smartsheet: We're utilizing Smartsheet to track start time and end time in a 24-hour clock to count the duration of some of the tasks we complete. How can I remove the time in "Created…
    Answered - Pending Review
    23 3
    Answered - Pending Review 23 views 3 comments Most recent by Jeff Reisman Formulas and Functions
  • Help: formula won’t apply to a new template
    In Formulas and Functions
    hello, when a new templete is submitted, my formula won’t apply to the new row. Other columns will apply the formula, however “End Time Parse Left” won’t. How can this be resolved? please see photo below:
    Accepted
    25 5
    Answered ✓ 25 views 5 comments Most recent by Genevieve P. Formulas and Functions
  • VLOOKUP on the if false of another VLOOKUP
    In Formulas and Functions
    I have a worksheet that I want to reference 5 reference sheets that contain staff members. Because of the large scale of staff members. We split them up by region. I want to create a column formula that will look up a "District ID&quo…
    Accepted
    18 1
    Answered ✓ 18 views 1 comment Most recent by Genevieve P. Formulas and Functions
  • Formatting not staying the same for new form fills
    In Formulas and Functions
    I noticed that in my sheets the $ currency column formatting or the align formatting do not stay the same as the rest of the column for new form fills. For example, before if I inputted in 100 in the $ section it would go to the sheet as $…
    Accepted
    24 4
    Answered ✓ 24 views 4 comments Most recent by Genevieve P. Formulas and Functions
  • SUMIF with cross sheet referencing
    In Using Smartsheet
    Hello all, I created a sumif formula that would reference another sheet.  Copied below is my formula but it always results as "incorrect argument". I believe the problem is in the sum range (bolded in formula). Can someone plea…
    1154 5
    1.2K views 5 comments Most recent by Seth Morth Using Smartsheet
  • Dynamic Drop-Down
    In Using Smartsheet
    Does anyone know if the options in a drop-down can be linked to a table? I have a sheet that users can pick a "provider" from a drop down list. That provider is associated with a vlookup that helps to populate other columns in th…
    Answered - Pending Review
    112 4
    Answered - Pending Review 112 views 4 comments Most recent by dqsoutherland Using Smartsheet
  • Way to have multiple people claim an item
    In Formulas and Functions
    Hello. I have a sheet that shows available material that our workers can "claim". I have a formula that populates the Available Quantity after a number is entered into the Quantity Claimed column. I am looking for a way to have m…
    Answered - Pending Review
    36 1
    Answered - Pending Review 36 views 1 comment Most recent by Kevin Smith Formulas and Functions
  • CountIF for a multi-select drop-down
    In Formulas and Functions
    Hello, I'm using a column to track what each row requires as a next step in the project. In some cases a row will need both say "requirement A" and "requirement B", therefore I'm using a multi-select dropdown because i…
    Accepted
    499 6
    Answered ✓ 499 views 6 comments Most recent by Megan P Formulas and Functions
  • VLOOKUP to another sheet using images
    In Formulas and Functions
    I love the new VLOOKUP functionality and am using it to try to reference IMAGES that I have stored in another sheet.However, I noticed that SmartSheet only pulls in the image name (example: imagename.jpg) and does not actually show the ima…
    823 17
    823 views 17 comments Most recent by deverajester Formulas and Functions