Join the Smartsheet Community

Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.

Discussion List

  • INDEX() function help
    In Formulas and Functions
    Hi, I have a master list of tasks in one sheet with project specific labeled columns. I'd like to break out those columns into separate sheets. My thought is the best way to keep the master list current while transposing data, using a com…
    Answered - Pending Review
    2 1
    Answered - Pending Review 2 views 1 comment Most recent by David Tutwiler Formulas and Functions
  • Help Creating a formula using Children
    In Formulas and Functions
    Hi! I currently am experimenting with Parent and Children Hierarchy to clean up my sheets. Below is a screenshot so you can see my mock up page. The issue I am running into is when I add an additional "Project", my formulas in t…
    Answered - Pending Review
    11 1
    Answered - Pending Review 11 views 1 comment Most recent by David Tutwiler Formulas and Functions
  • Today / Yesterday formulas
    In Formulas and Functions
    Hi all, I need to create a dashboard to include all calls made to clients, either today or yesterday (the idea being that the charts would change on a daily basis). My issue is that I don't think I can use the Today or Today -1 type formu…
    Answered - Pending Review
    12 5
    Answered - Pending Review 12 views 5 comments Most recent by David Tutwiler Formulas and Functions
  • Contact List is NOT restricted in Report
    In Using Smartsheet
    I'm wondering if someone knows what's going on here! In our main sheet, the contact column (Crew) is restricted to 2 contacts, but in the report that drop down is showing many other contacts. I have the contact column in the main sheet set…
    7 0
    Question 7 views 0 comments Started by AmandaM Using Smartsheet
  • Once approved, send attachment to Cloud Folder?
    In Using Smartsheet
    I have a sheet with a workflow that requires someone to approve the attachment. Once they do this, I'd like for the attachment from that line to be uploaded to a cloud folder. How can I accomplish this without reinventing the wheel? Bonus…
    4 0
    Question 4 views 0 comments Started by Riza Khan Using Smartsheet
  • Tracking date when a drop down value is selected
    In Formulas and Functions
    I'm creating a project tracker where I can assign what phase the project is at (design, prototype and complete). What I want to do is track how long the project is in each phase, so what I plan on doing is tracking when the drop down items…
    Answered - Pending Review
    13 2
    Answered - Pending Review 13 views 2 comments Most recent by Cole Fuerste Formulas and Functions
  • Can we unshare one person on multiple sheets or workspaces at once?
    In Using Smartsheet
    Is it possible to unshare multiple sheets at a time that a person is assigned to? we let someone go and need to unshare all the sheets associated with that person. if not possible can we make it possible in the future? thanks Scott
    Answered - Pending Review
    2 3
    Answered - Pending Review 2 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Fillable PDF
    In API & Developers
    Has anyone tried to use the submit button on a fillable PDF form to send data into smartsheet?  Doens't seem to difficult but could use some guidance.
    710 views 16 comments Most recent by Emily Alloy API & Developers
  • SmartSheet Alert Mail Sender
    In Using Smartsheet
    Hi all, I am the owner of 10 sheets each of one is used by different users. I have set up alerts automation but when the email is sent, it is always shown my email address instead of that of the user. This is a problem as the email is sent…
    Answered - Pending Review
    4 1
    Answered - Pending Review 4 views 1 comment Most recent by Mary_A Using Smartsheet
  • Charts in Dashboard
    In Using Smartsheet
    Good morning.  I've been playing around with the new chart feature in Dashboards and I'm having some difficulty with percentages.  It defaults to 200% using up valuable space on the dashboard.  How can I reduce that to 100%?  (Image)
    13 views 8 comments Most recent by Kara Price Using Smartsheet