Discussion List

  • Is there a way to have a date change in autofill within a formula?
    In Formulas and Functions
    I am looking to shift the way my data is displayed so I can place it in a dashboard. To do this, I'd like to shift the information within to do a specific date and return that. My formula works fine, but I have to change the date for eve…
    12 4
    Accepted Answer 12 views 4 comments Most recent by Andrée Starå Formulas and Functions
  • Notifications to Company Managed Distribution Lists
    In Using Smartsheet
    Now that smartsheet permits emails to outside users my ability to use the sheets has greatly increased! Unfortunately I am running into an issue when trying to send emails to company generated distribution lists. I am not sure if it a secu…
    304 7
    Accepted Answer 304 views 7 comments Most recent by Mark Katz Using Smartsheet
  • Excel Import
    In Using Smartsheet
    What are the prerequisites for importing an Excel spreadsheet into a new sheet.  I read number of columns, size and row constraints, which my Excel spreadsheet meets.  I am getting a warning regarding fields cannot be more than 50 characte…
    Answered - Pending Review
    196 3
    Answered - Pending Review 196 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Dropdown Multi select - ~If formula
    In Formulas and Functions
    Hi all,   Been searching about this, but could not find anything so far. Hopefully you can help me. I am just starting to make use of the multi select dropdown list. So i have a spreadsheet with some information in the first few column…
    1129 8
    1.1K views 8 comments Most recent by Genevieve P Formulas and Functions
  • Do Smartsheet Forms have the ability to add in image files (not logos)?
    In Using Smartsheet
    Use case: would like to add an illustration/image to go accompany a question asked on the form to better illustrate the information being sought.
    Answered - Pending Review
    15 1
    Answered - Pending Review 15 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Rolling Months on Pivots and KPIs
    In Using Smartsheet
    I have a question on how to update my KPI's where the data populates by month and will automatically start copying from the new month while dropping out an old month that is 13 months back? This will always show me the latest 12 months. …
    Answered - Pending Review
    18 5
    Answered - Pending Review 18 views 5 comments Most recent by Paul Newcome Using Smartsheet
  • Sum of Max Value across multiple rows
    In Formulas and Functions
    Hello, I need some help working out a formula that will let me sum the max value across 2 conditions... I have a data sheet that is getting rows copied to is when values are changed on multiple project sheets and i need to have a formula o…
    Answered - Pending Review
    17 3
    Answered - Pending Review 17 views 3 comments Most recent by Bassam Khalil Formulas and Functions
  • Validating data input in a Form
    In Formulas and Functions
    I have set up smartsheets to collect data with forms for the users at our facilities. The operators check equipment and enter the data in the form. Sometimes, they fat finger it - or forget the decimal point which causes an out of spec con…
    841 3
    841 views 3 comments Most recent by Moses Ali Formulas and Functions
  • Forms that need to incorporate multiple line entries
    In Formulas and Functions
    We currently use Jotform for some of our forms here and would like to be able to bring more of them over to Smartsheet if possible As you can see from the attached files, the form is set up to add a new line after each previous line is fi…
    390 21
    390 views 21 comments Most recent by Andrée Starå Formulas and Functions
  • Hidden Fields in Card View
    In Using Smartsheet
    Is there a way to HIDE fields in the card view, just like you can hide columns in a grid view? I have fields hidden in my grid, but when I go into a card view and click into the card ALL the fields are visible. I have set the 9 visible fie…
    294 6
    294 views 6 comments Most recent by sas-ss Using Smartsheet