Construction

Discussion List

  • Automatic Children Indenting
    In Using Smartsheet
    Hello,   Is it possible to set up a formula for information (if it is the exact same as the parent/child row above) that you have underneath a child/parent row to automatically attach itself inside the Parent/Child Hierarchy? I would rat…
    1903 21
    1.9K views 21 comments Most recent by Paul Newcome Using Smartsheet
  • Zero Formula
    In Formulas and Functions
    Where do I find the formula to have a cell display nothing when the total becomes the number zero? I have a sheet with zeros in multiple places and it clutters to much. 
    Answered - Pending Review
    1832 34
    Answered - Pending Review 1.8K views 34 comments Most recent by BenG0706 Formulas and Functions
  • 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…
    1587 5
    1.6K views 5 comments Most recent by L_123 Formulas and Functions
  • RTF in Dashboard Widget
    In Using Smartsheet
    I downloaded an example dashboard which tracked multiple projects.  Looked good and decided to build my dashboard to match example.  Example dashboard has a Rich Text Widget which has multiple formats within.  However when I try to use the…
    695 12
    695 views 12 comments Most recent by Roland Horwood Using Smartsheet
  • Kanban View - printing or saving to PDF
    In Using Smartsheet
    In the Kanban sheet, can this be saved to PDF in card view or printed in card view ? currently it shifts to list view when printing.
    558 8
    558 views 8 comments Most recent by Alberto Ferrari Using Smartsheet
  • Start and end date line chart
    In Using Smartsheet
    Hi Team, Can anyone help me how can I create a line chart based on below information. I
    Answered - Pending Review
    55 3
    Answered - Pending Review 55 views 3 comments Most recent by Christina.R Using Smartsheet
  • If and Find
    In Formulas and Functions
    If cell A3 contains "ABC" then enter "ABC" in cell A1. Can someone help me do this in smartsheet?   I tried using =If(find("ABC",A3,)="ABC","ABC","X")  but its not working.   …
    405 6
    405 views 6 comments Most recent by Pam Grant Formulas and Functions
  • Update Columns in Existing Row Using Forms
    In Using Smartsheet
    Hello, I have a sheet where I am tracking construction progress.  There are a lot of data/calculations that my field personnel do not need.  I want a simple interface for them to update data (% Complete, Actual Date Completed, etc.)  Each…
    1383 9
    1.4K views 9 comments Most recent by Paul Newcome Using Smartsheet
  • Dependency Logic based on one or the other predecessor tasks
    In Formulas and Functions
    Is is possible to create schedule logic where a dependent task is dependent on one of two predecessors (either or not both)? For Example: I am trying to build out a schedule template for if a permit is required vs not for a specific projec…
    Answered - Pending Review
    47 1
    Answered - Pending Review 47 views 1 comment Most recent by Genevieve P. Formulas and Functions
  • Rows will not stay in place. NEED HELP NOW
    In Using Smartsheet
    We use a sheet as both a schedule and data collection tool as part of a much larger system we just put in place (literally 5 days ago, moved from google sheets). The information is organized manually first by employee and second by the pri…
    684 15
    684 views 15 comments Most recent by BrittColby Using Smartsheet