Support
Discussion List
-
Reference Predecessor Cell / INDIRECT FunctionIn Formulas and FunctionsI'm using a formula to automate a status column that updates based on dates and/or a "Complete" checkbox. The formula has to reference the task before and I've gotten that to work just fine if it's the literal task before. My …Answered - Pending Review 27 views 3 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Jira Connector: Where did the lightning bolt shortcut go?In Apps, Integrations, and Add OnsThere used to be a jira connector shortcut that looked like a lightning bolt on the vertical menu that seems to have disappeared for everyone at my company. Does anyone know how to get this back?Accepted Answer 10 views 1 comment 0 points Most recent by Genevieve P. Apps, Integrations, and Add Ons
-
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…
-
SUM of Only Parents in Budget SheetIn Formulas and FunctionsHello! I've created a budget sheet with sub items. I figured out how to SUM the Children under a Parent line but what is the simplest way to SUM only the Parents for a Total that does not include both Children and Parents? Thank yo!Answered - Pending Review 7 views 1 comment 0 points Most recent by Sameer Karkhanis Formulas and Functions
-
Dashboard Chart Widget Axis changes with each refreshIn Formulas and FunctionsThe axis label on the dashboard chart widgets consistently changes with each refresh and will not maintain the order that it is in on the Report. This is pulling from a summary report. Occurring on a monthly report widget and quarterly. …
-
Effort Vs DurationIn Using SmartsheetHi I am new to smartsheet and wondered if you could help. I would like to create a project plan which shows the effort required vs the duration. for example: a task may take 2 days to complete however they can complete this anytime with…
-
Assign Workflow issueIn Using SmartsheetI think I've been looking at this for too long and I need help! I received this message "We had additional conditions set up that didn't show disabled, but wouldn't assign on this workflow so we changed them to be OR and apparently it…Answered - Pending Review 31 views 4 comments 0 points Most recent by adegeus101536 Using Smartsheet
-
Formula to auto-transfer data into another sheetIn Using SmartsheetThe company I work for uses Smartsheets to build schedules. We have both weekly and daily schedules. However, I've noticed a lot of our time is spent daily going through and transferring information from the weekly to the daily grids. I di…
-
Formula to automate the symbols on a sheet.In Formulas and FunctionsThe Task Progress column is linked to the % Complete column. when someone inputs a value of 100% in the % complete column, the task progress changes to a Green dot, and the same goes for when the % complete is 0% - Red dot, 1-99% - Yellow…
-
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…
