Discussion List

  • Reference Predecessor Cell / INDIRECT Function
    In Formulas and Functions
    I'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 3
    Answered - Pending Review 27 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Jira Connector: Where did the lightning bolt shortcut go?
    In Apps, Integrations, and Add Ons
    There 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?
    10 1
    Accepted Answer 10 views 1 comment Most recent by Genevieve P. Apps, Integrations, and Add Ons
  • 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
  • SUM of Only Parents in Budget Sheet
    In Formulas and Functions
    Hello! 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 1
    Answered - Pending Review 7 views 1 comment Most recent by Sameer Karkhanis Formulas and Functions
  • Dashboard Chart Widget Axis changes with each refresh
    In Formulas and Functions
    The 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. …
    17 2
    Accepted Answer 17 views 2 comments Most recent by Kayla Formulas and Functions
  • Effort Vs Duration
    In Using Smartsheet
    Hi 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…
    Em Profile Photo Em
    1793 12
    1.8K views 12 comments Most recent by Ted Hassanein Using Smartsheet
  • Assign Workflow issue
    In Using Smartsheet
    I 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 4
    Answered - Pending Review 31 views 4 comments Most recent by adegeus101536 Using Smartsheet
  • Formula to auto-transfer data into another sheet
    In Using Smartsheet
    The 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…
    Answered - Pending Review
    43 3
    Answered - Pending Review 43 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Formula to automate the symbols on a sheet.
    In Formulas and Functions
    The 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…
    47 4
    Accepted Answer 47 views 4 comments Most recent by Paul Newcome 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