Solution Center
Discussion List
-
How to Fix: Value of Parent Row (days) Not Showing the Sum of the Childrens' Rows (days)In Formulas and FunctionsWe 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…
-
Piechart does not reflect the correct percentage-Showing 100%In Formulas and FunctionsMy 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.
-
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 244 views 17 comments 1 point Most recent by Andrée Starå Using Smartsheet
-
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?
