Discussion List

    In Formulas and Functions
    Hi  =ROUND(SUMIF($[Pareto Category]$32:$[Pareto Category]558, Predecessors21, $[Actual (MHrs)]$32:$[Actual (MHrs)]558), 0) The above is my formula. It says, "IF the value in the Pareto Category column is the same as the value in th…
    71 2
    71 views 2 comments Most recent by Amy Scherer Formulas and Functions
  • Update Confirmation email limitations
    In Using Smartsheet
    Has anyone figured out a way to disable the update confirmation email that is sent following an update request? The email is confusing my user community because it links to a sheet they don't have access to. Is it possible to even change t…
    230 2
    230 views 2 comments Most recent by Caroline S. Using Smartsheet
  • SUMIFS & FIND functionality with Summary Sheets
    In Formulas and Functions
    Hi All, I checked the archives and couldn't find a solution to my problem so I apologize if this has already been asked. I am trying to create a formula for my Summary Sheet that will provide the sum of dollar amounts but only if they are…
    CL- Profile Photo CL-
    162 3
    162 views 3 comments Most recent by Sinema Formulas and Functions
  • Reporting like pivot or sumif. How to roll up values by name or category?
    In Formulas and Functions
    Is there a way to combine cell entries and give the total assigned to that category? Ex.    Project Lead      Cost savings John                      $100 Mary                      $500 Bob                         $400 John           …
    358 5
    358 views 5 comments Most recent by Mailys Formulas and Functions
  • 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…
    235 19
    235 views 19 comments Most recent by Andrée Starå Formulas and Functions
  • Returning last entry in a database column
    In Using Smartsheet
    I have created a database that adds a new line against a date each day. From this I am building some metrics and then a dashboard which will show Daily Performance but also week to date, annual etc. I am struggling to reference the databa…
    Answered - Pending Review
    170 12
    Answered - Pending Review 170 views 12 comments Most recent by Adam Kinney Using Smartsheet
  • 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…
    642 6
    642 views 6 comments Most recent by Aaron Hillyer Using Smartsheet
  • Is the Email Notification highlight color yellow definable?
    In Using Smartsheet
    In a standard email notification for sheet updates the changes are shown in yellow in the email body, is there a way to define that color to something other than yellow?
    431 views 6 comments Most recent by Clark Draffin Using Smartsheet
  • Digital Signature
    In Using Smartsheet
    Hi all,   I've searched for this topic, but i could not find directly what  i was looking for. Is there on Smartsheet any functionality for digital signature that doesn't require pairing our service with another software? All the solut…
    1824 8
    1.8K views 8 comments Most recent by Mily Oti Using Smartsheet
  • 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 …
    1123 8
    1.1K views 8 comments Most recent by Jake Gustafson Using Smartsheet