Discussion List

  • 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. …
    1344 14
    1.3K views 14 comments Most recent by Pam Ferguson Formulas and Functions
  • 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
    349 4
    Answered - Pending Review 349 views 4 comments Most recent by Madalyn Nelson Using Smartsheet
  • Creating training Calendar
    In Formulas and Functions
    Hi All, I am currently trying to create a sheet to track who our trainers are currently working with. Currently have 15 trainers, but the team will grow larger in the next few months. Each trainer can train 2 employees at a given time. Emp…
    Answered - Pending Review
    25 8
    Answered - Pending Review 25 views 8 comments Most recent by Genevieve P. Formulas and Functions
  • Reference Codes
    In Formulas and Functions
    Hi, I am looking to have a single reference code or number that is attached to an update request that contains multiple rows. Is there a best way to do this? My first thought is to have a value added to a cell when the reference goes out…
    Answered - Pending Review
    11 2
    Answered - Pending Review 11 views 2 comments Most recent by bvannuland Formulas and Functions
  • Can I hide predecessor lines in a gantt chart?
    In Using Smartsheet
    I have a complicated project with tons of predecessors.  The predecessor lines connecting tasks in the gantt view are so numerous that is makes the gantt visually hard to use.  Is there are way to hide or turn off not the predecessors, but…
    1462 11
    1.5K views 11 comments Most recent by Bakercito Using Smartsheet
  • Time Tracking - Hours and Minutes
    In Formulas and Functions
    I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-ar…
    1348 5
    1.3K views 5 comments Most recent by L_123 Formulas and Functions
  • How to add an Image into a cell in a Report
    In Using Smartsheet
    We have a single sheet broken into many reports that different users use during a process of development of a product. The sheet holds all the columns and is the single source of truth while the reports give snap shots of each step and onl…
    45 3
    Accepted Answer 45 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Please add a successor column or function
    In Using Smartsheet
    A way to show successors is needed. It's important for critical path scheduling that every task has a predecessor and a successor. After a couple hundred lines it becomes nearly impossible to eyeball everything to make sure that's true. A …
    635 4
    635 views 4 comments Most recent by AW10101 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
    74 7
    Answered - Pending Review 74 views 7 comments Most recent by Paul Newcome Using Smartsheet
  • 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…
    588 24
    588 views 24 comments Most recent by Karen M Formulas and Functions