Discussion List

  • 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…
    1137 3
    1.1K views 3 comments Most recent by Moses Ali 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…
    448 6
    448 views 6 comments Most recent by sas-ss Using Smartsheet
  • How can i get a group of information to autopopulate by selecting a dropdown?
    In Formulas and Functions
    Hello, I am trying to figure out how i can get 5 or more different rows to auto populate from selecting one dropdown. when I select a dropdown for example 48-3, I want it to fill out the 3 columns like the above pic. This is for a manu…
    Answered - Pending Review
    31 2
    Answered - Pending Review 31 views 2 comments Most recent by Mark Cronk Formulas and Functions
  • Help with Trend Data
    In Formulas and Functions
    I need some help with collecting data for trending.  Currently, I have multiple projects with all of their top line data dynamically linked to a Roll-up Sheet.  On this roll-up sheet I have data that is calculated from the project Status. …
    1340 13
    1.3K views 13 comments Most recent by Andrée Starå Formulas and Functions
  • Order Pipeline Model template
    In Using Smartsheet
    I'm a Smart Sheet noob and as I was watching the first Card View video I saw the Sprockets Sample which was referred to as an "Order Pipeline Model". This is very close to what I need to track our large orders of partially machin…
    41 5
    41 views 5 comments Most recent by Genevieve P. Using Smartsheet
  • Nest IF AND OR multiple layers to get a RED or GREEN Result/Status
    In Formulas and Functions
    This is my challenge below. I spelled it out in the screen shot. I need an overall status of Red or Green based on duration correlated to phase status.... Looking for help:
    Answered - Pending Review
    11 2
    Answered - Pending Review 11 views 2 comments Most recent by Garry Formulas and Functions
  • How to set recurring reminders
    In Using Smartsheet
    I have been searching through the posts and found this formula: =IF(Complete4 = 0, TODAY(), “”) using my own column names. Each time I've tried to accept the formula, I get this error message: unparseable. Am I missing some of the formula …
    2228 11
    2.2K views 11 comments Most recent by Genevieve P. Using Smartsheet
  • Multiple Approvals Per Row
    In Using Smartsheet
    Hello,  I am looking for a workflow solution to our document approval process. Currently we have a Confluence page where five individuals attach a picture of their signature.  I would like to set up a sheet to manage approvals of several…
    1193 15
    1.2K views 15 comments Most recent by Stacey Rodriguez Using Smartsheet
  • Alert Task Owner when change is made by someone else
    In Using Smartsheet
    Hello All, I have a task sheet that is shared with multiple users.  I have a field for the name of the Project Manager and a field for the name of the Task Owner.  I would like the PM to get an alert when the row is updated but only if th…
    445 5
    445 views 5 comments Most recent by Kea Jolicoeur Using Smartsheet
  • Does anyone know a way for tracking quantity deduction when it comes to material requests ?
    In Using Smartsheet
    I have been trying to track via the activity log on the right hand of the sheet, however the reports are taking too long to produce. I just need something that i can send to the accounts team that shows how much material was used in a week…
    Answered - Pending Review
    13 3
    Answered - Pending Review 13 views 3 comments Most recent by Debbie Sawyer Using Smartsheet