Formulas

Discussion List

  • Formula Help-Finding the minimum value greater than zero
    In Archived 2015 Posts
    Hello Smartsheet Community, The formula I used in Microsoft Excel needed to be entered as an array.   What is the best way/formula to find the minimum value in a range that is not zero?  
    202 1
    Closed 202 views 1 comment Most recent by Jim Hook Archived 2015 Posts
  • Formula
    In Archived 2015 Posts
    I'm trying to build a formula.   Date range based off Finish date.    Currently I have a date in the Finish date cell and it will populate a text based off the finish date but I really want to do a date range now based off the finish d…
    21 8
    Closed 21 views 8 comments Most recent by jenmiller Archived 2015 Posts
  • Nesting Formulas
    In Archived 2015 Posts
    I need some help with nesting formulas for the following screenshot:   What I'm trying to accomplish is an automatic change in the "Status" Column based on the following criterias:   1) If "%Complete" >= 1% and…
    305 2
    Closed 305 views 2 comments Most recent by Travis Archived 2015 Posts
  • Excel formula =SQRT()
    In Archived 2015 Posts
    I am looking for a similar foruma to =SQRT() in Excel.  Does Smartheet have this feature/function in its formula list?
    134 4
    Closed 134 views 4 comments Most recent by Asle Gaarder Archived 2015 Posts
  • Graphic for pipeline
    In Archived 2015 Posts
    Hi, I am an architect and I NEED to see all the data graphically. I am looking for samples of project pipeline graphics produced using Smartsheet.  Please, post them here or send me a link.  Thanks! ileana
    14 1
    Closed 14 views 1 comment Most recent by JohnHinkle Archived 2015 Posts
  • Tracking Assigned Tasks
    In Archived 2015 Posts
    Dears,   How to view a specific person tasks on smartsheet, i assign multiple tasks for multiple users so what is the best way to keep informed or to check the update of a specific person tasks.   Thanks.    
    2 1
    Closed 2 views 1 comment Most recent by JamesR Archived 2015 Posts
  • SUM Parent without Children?
    In Archived 2015 Posts
    I've been able to figure out how to SUM children under parents, but is there a way to SUM just the parent rows?   For instance:   NAME  NUMBER  Parent: 10,000 Child: 10 Child: 10 Parent: 10,000 Child: 10   SUM (Parent only): 20,…
    625 3
    Closed 625 views 3 comments Most recent by Travis Archived 2015 Posts
  • Finding the most recent date for one person
    In Archived 2015 Posts
    I work at an University and we are trying out smartsheet for keeping a log of when instructors have taught. In one sheet I have a column for the start date of the course, the end date, the name of the course and the instructors name.    …
    307 1
    Closed 307 views 1 comment Most recent by Travis Archived 2015 Posts
  • Calculating Durations
    In Archived 2015 Posts
    I have columns in my sheet with "Departure TIme" and "Arrival Time" in the format hh:mm   Since there is no "Time" Type for the columns, so I had to kep the Column Type as Number/Text   I am looking for a …
    41 4
    Closed 41 views 4 comments Most recent by Patrick Lawler Archived 2015 Posts
  • Formula to sum from different sheet
    In Archived 2015 Posts
    Can I do a forumla =sum(range of cells on a different sheet)? 
    172 1
    Closed 172 views 1 comment Most recent by JamesR Archived 2015 Posts