Discussion List

  • 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…
    250 5
    250 views 5 comments Most recent by Eric Eskam Using Smartsheet
  • 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…
    18 3
    18 views 3 comments Most recent by Genevieve P Using Smartsheet
  • 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. …
    851 11
    851 views 11 comments Most recent by Andrée Starå Formulas and Functions
  • 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
    12 2
    Answered - Pending Review 12 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 …
    1466 11
    1.5K 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…
    759 15
    759 views 15 comments Most recent by Stacey Rodriguez Using Smartsheet
  • Best Practices for managing 60+ projects in Smartsheet
    In Using Smartsheet
    Hello, I am a fairly new user of Smartsheet and have recently started at a construction company as a project manager where we design manufacture and erect large steel buildings for rural and industrial use. (From farm sheds through to airc…
    Answered - Pending Review
    35 7
    Answered - Pending Review 35 views 7 comments Most recent by Andrée Starå 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…
    298 5
    298 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
    14 3
    Answered - Pending Review 14 views 3 comments Most recent by Debbie Sawyer Using Smartsheet
  • Find highest value and return matching column header
    In Using Smartsheet
    Hi Everyone, I have to inspect several cavities in a process by using a Smartsheet form. Then, out of this database, I would like to know the highest and lowest cavity weight along with the cavity #. I wonder how can I do that. Here is …
    33 3
    Accepted Answer 33 views 3 comments Most recent by Isaac Gallardo Using Smartsheet