Solution Center
Discussion List
-
Calculate Reverse Date FormatIn Formulas and FunctionsHi 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…
-
Format as timeIn Using SmartsheetI 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…
-
How do I auto-save a sheet without opening the sheet?In Using SmartsheetI 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 views 17 comments 1 point Most recent by Andrée Starå Using Smartsheet
-
Help on formula: count if with multiple criteriaIn Formulas and FunctionsHi 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…
-
COMPLEX INDEX/MATCH arguments issue: Project Updates TasklistIn 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…
-
UPPER formulasIn Formulas and FunctionsIs 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?
-
Can I start multiple workflow in the same time and using same form?In Using SmartsheetI 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)…
-
Alerts stopped workingIn Using SmartsheetLate 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…
-
Automation QuestionIn Using SmartsheetGood 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?
-
Auto Delete rowsIn Using SmartsheetHI, 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.
