Solution Center


Discussion List

  • 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
    16 3
    Answered - Pending Review 16 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…
    71 4
    71 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
    206 17
    Answered - Pending Review 206 views 17 comments Most recent by Andrée Starå Using Smartsheet
  • Help on formula: count if with multiple criteria
    In Formulas and Functions
    Hi all, I'm trying to get the count of active projects in my tracker sheet however I'm getting zero as a result. Please, can you check and advise what should be the correct formula? Here's the formula I used: =COUNTIFS(Stage:Stage, &quo…
    9177 43
    9.2K views 43 comments Most recent by Paul Newcome Formulas and Functions
  • 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…
    15 3
    Accepted Answer 15 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?
    187 3
    187 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
    11 1
    Answered - Pending Review 11 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…
    11 4
    11 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?
    21 4
    Accepted Answer 21 views 4 comments Most recent by Gabby M. Using Smartsheet
  • Auto Delete rows
    In Using Smartsheet
    HI, I would like to know please what will be the best way to delete rows which their time stamp i more than 24 hours. i can't find a delete function under the conditionl function.
    1027 9
    1K views 9 comments Most recent by Genevieve P. Using Smartsheet