Discussion List

  • Automation - How to Send One Email Notification for Each Changed Row
    In Using Smartsheet
    I am using automation for one of our request approval processes, and need to be able to notify our help desk support team anytime the Completion Date column is updated with a date. I know how to do this, however, I can't figure out how to…
    945 16
    945 views 16 comments Most recent by Cathy Fraser 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
    44 6
    Answered - Pending Review 44 views 6 comments Most recent by Andrée Starå Using Smartsheet
  • Piechart does not reflect the correct percentage-Showing 100%
    In Formulas and Functions
    My 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.
    412 9
    Accepted Answer 412 views 9 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?
    12 1
    Accepted Answer 12 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
    24 3
    Answered - Pending Review 24 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
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Sameer Karkhanis 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
    1904 12
    1.9K views 12 comments Most recent by Ted Hassanein 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…
    73 4
    Accepted Answer 73 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…
    82 4
    82 views 4 comments Most recent by Sheryl Roland Using Smartsheet