Solution Center

Discussion List

  • How to Fix: Value of Parent Row (days) Not Showing the Sum of the Childrens' Rows (days)
    In Formulas and Functions
    We may have run into a bug with a value on a parent row. The duration of days should be 15 days because the sum of the childrens' rows is 15 (5 tasks, 3 days each), but the parent row displays 25 days. Where could this be pulling from? Ca…
    Des Profile Photo Des
    Accepted
    22 3
    Accepted Answer 22 views 3 comments Most recent by Genevieve P. Formulas and Functions
  • Piechart does not reflect the correct percentage-Showing 100%
    In Formulas and Functions
    My pie chart is linked to a cell that says 25% complete. The pie chart says 25% but has (100%) next to it and shows a whole pie chart. I was hoping it would show only 25% of the pie not the whole pie.
    Accepted
    415 9
    Accepted Answer 415 views 9 comments Most recent by Paul Newcome Formulas and Functions
  • Calculate Reverse Date Format
    In Formulas and Functions
    Hi dears if someone can help with this format I have 3 cells: 1-ESTIMATED REQUIRED DELIVERY DATE: include the estimated date of delivery 2-PROCUREMENT TIMELINE: autogenerated including the number of working days 3-PR ESTIMATED SUBMISSION D…
    Answered - Pending Review
    24 3
    Answered - Pending Review 24 views 3 comments Most recent by Alim Formulas and Functions
  • Format as time
    In Using Smartsheet
    I need to keep accurate documentation of how long my deliveries take (down to the minute) I normally do this in spreadsheets by having the column formatted as a time. I cannot see that option in the formatting list. Am I blind or is it not…
    83 4
    83 views 4 comments Most recent by Sheryl Roland Using Smartsheet
  • How do I auto-save a sheet without opening the sheet?
    In Using Smartsheet
    I use conditional formatting. When I review the dashboard, the formatting doesn't update until I go to the sheet and save. I would like the sheet to save automatically when conditional formatting makes changes. Thank You.
    Answered - Pending Review
    244 17
    Answered - Pending Review 244 views 17 comments Most recent by Andrée Starå Using Smartsheet
  • COMPLEX INDEX/MATCH arguments issue: Project Updates Tasklist
    In Formulas and Functions
    @Paul Newcome @Paul Newcome I need your expertise My manager has tasked me with referencing data from a hierarchy of rows, for multiple columns, but wanting the Parent Row to be updated from the inputs of the data in the CHILDREN rows, wh…
    Accepted
    26 3
    Accepted Answer 26 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • UPPER formulas
    In Formulas and Functions
    Is there a way to set a formula so all text in the column or sheet is upper case even if someone enters it on a form in lower or title case?
    216 3
    216 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • Can I start multiple workflow in the same time and using same form?
    In Using Smartsheet
    I am tyring to make an ERP system. I created workflow to approved from the purchasing department and its department's manager with email. However, i want to add multiple items in the same time and same form to approved(in item code column)…
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Alerts stopped working
    In Using Smartsheet
    Late yesterday on 04/04/2019 our alerts on more than one of our sheets stopped working.  I turned some on and off and tested a few different sheets, but they are all not working. I know I received an Update from Smartshets yesterday that S…
    12 4
    12 views 4 comments Most recent by Gee114 Using Smartsheet
  • Automation Question
    In Using Smartsheet
    Good day everyone! new to smartshets and hoping to get some help. Is there a way to have an automation that will recognize multiple values (ie: ABC = Gabby, BCD= Debbie) or do I have to create an individual automation for each value?
    Accepted
    22 4
    Accepted Answer 22 views 4 comments Most recent by Gabby M. Using Smartsheet