Solution Center

Discussion List

  • Is there an automated workflow that populates data in cells based on triggers and conditions?
    In Using Smartsheet
    Hi Smartsheet SMEs! Please share any success you've experienced in creating a workflow to automatically populate cells using select triggers and conditions without using a formula. Thanks in advance for your feedback/suggestions. Edwina -
    Answered - Pending Review
    52 5
    Answered - Pending Review 52 views 5 comments Most recent by Edwina Sampler-Wright Using Smartsheet
  • translating Content
    In Using Smartsheet
    Hi all, Looking for any ideas, I am working on a sheet that is being used in 10 countries, currently, we use English as the main language, however, content can get lost in translation.  is there any way for users to use their home languag…
    769 6
    769 views 6 comments Most recent by Zack Miller Using Smartsheet
  • OFFSET Function
    In Formulas and Functions
    Hi, I need to calculate the sum across a number of columns that will change every month (mon columns are set from January to December for each year). This would easily be done in Excel via an OFFSET function and I can't find what the equiv…
    Answered - Pending Review
    113 5
    Answered - Pending Review 113 views 5 comments Most recent by Heather Duff Formulas and Functions
  • Report builder - Collapse and Expand Rows
    In Using Smartsheet
    Hi, Is there a way to expand and collapse rows in the report builder just like the functionality that the sheets have? I want to be able to display in my project dashboard the same view that from the project sheet but unable to do so bec…
    364 4
    364 views 4 comments Most recent by Chris Atkinson Using Smartsheet
  • Dropdowns in a dashboard, is it possible?
    In Using Smartsheet
    I have one sheet that has metrics for a few of my employees, I was hoping there was a way to get the drop down menu function for each employee transferred onto a Dashboard highlighting everyone's metrics. *The drop downs show their total …
    1233 11
    1.2K views 11 comments Most recent by Andres Londono Using Smartsheet
  • Max Cost per Year
    In Formulas and Functions
    I need to determine the max Remediation Cost PER Year. I also, need to pull this information into another sheet's cell. What's the best way to go about this? This is the formula I have thus far, but it's coming out UNPARSEABLE... =MAX(IF([…
    Answered - Pending Review
    45 2
    Answered - Pending Review 45 views 2 comments Most recent by Genevieve P. Formulas and Functions
  • Completed Tasks removed from calendar
    In Using Smartsheet
    Is there a way to remove completed tasks from the calendar without removing them from the sheet? I have a done column that checks off and greys out the row but the information still shows up on the calendar is there a way for it not to sho…
    Answered - Pending Review
    42 2
    Answered - Pending Review 42 views 2 comments Most recent by Sara Moore Using Smartsheet
  • Workflow and cell linking.
    In Using Smartsheet
    I have two sheets that have linked cells. I want to use the workflow to make the tasks from the second sheet disappear if the Status column says complete. Is this possible? I know how to set up a workflow to move cells to a new sheets but …
    Answered - Pending Review
    85 2
    Answered - Pending Review 85 views 2 comments Most recent by Sara Moore Using Smartsheet
  • How to create a time gauge or something similar?
    In Using Smartsheet
    Hello, I am trying to create a widget to display on a dashboard. This widget will give the viewer an immediate idea of where the project is in the project timeline. Ideally, the widget would look like the time gauge image attached. There …
    124 1
    Accepted Answer 124 views 1 comment Most recent by Mark Cronk Using Smartsheet
  • Can a Smartsheet form populate a PDF, and then send that PDF to Slack
    In Using Smartsheet
    Hi My company has a logistics driver that delivers sets to theatre. He usually fills in a paper form of what he has dropped off and then takes a picture of that and posts it on Slack. We have decided to move over to a paperless system and …
    Answered - Pending Review
    43 1
    Answered - Pending Review 43 views 1 comment Most recent by Genevieve P. Using Smartsheet