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…

  Julie_Boss85141

  11/08/21

  1903 21

  1.9K views 21 comments 0 points Most recent by Paul Newcome 11/08/21Using 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. 

  Ryan Coles

  11/04/21

  Answered - Pending Review

  1832 34

  Answered - Pending Review 1.8K views 34 comments 0 points Most recent by BenG0706 11/04/21Formulas 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…

  Ezra

  11/02/21

  1587 5

  1.6K views 5 comments 1 point Most recent by L_123 11/02/21Formulas 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…

  Paul Stell

  11/02/21

  695 12

  695 views 12 comments 0 points Most recent by Roland Horwood 11/02/21Using 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.

  glenn.crowhurst36241

  11/01/21

  558 8

  558 views 8 comments 1 point Most recent by Alberto Ferrari 11/01/21Using 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

  Finops C'ship

  10/28/21

  Answered - Pending Review

  55 3

  Answered - Pending Review 55 views 3 comments 0 points Most recent by Christina.R 10/28/21Using 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.   …

  Debbie J

  10/26/21

  405 6

  405 views 6 comments 0 points Most recent by Pam Grant 10/26/21Formulas 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…

  John.Bruzza

  10/22/21

  1383 9

  1.4K views 9 comments 0 points Most recent by Paul Newcome 10/22/21Using 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…

  Megcald17

  10/15/21

  Answered - Pending Review

  47 1

  Answered - Pending Review 47 views 1 comment 1 point Most recent by Genevieve P. 10/15/21Formulas 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…

  OrbitalPorcupus

  10/15/21

  684 15

  684 views 15 comments 0 points Most recent by BrittColby 10/15/21Using Smartsheet