Using Smartsheet

Want to know more about using forms? Interested in better understanding automation? Want to see what's possible with dashboards? Post your question or discussion to Using Smartsheet.

Discussion List

  • Why do some columns (fields) not appear in a new form?
    In Using Smartsheet
    Hi, I'm a new user. I created a Smartsheet with roughly 60 columns for a survey form, but not all of these appear when I create a form. Forty-eight (48) of these columns are Dropdown (Multi Select). Each column represents a month of the ye…
    Accepted
    193 12
    Accepted Answer 193 views 12 comments Most recent by Genevieve P
  • Functional Requirements in Smartsheet
    In Using Smartsheet
    Hello, Our project team recently transitioned to Smartsheet.  I am currently deciding how we will develop Functional Requirements (e.g. Excel, Smartsheet, Word, One Note, etc.) and eventually test cases.  Is there anyone using Smartsheet …
    355 views 9 comments Most recent by Genevieve P
  • COUNTIFS Blank, Not Blank
    In Using Smartsheet
    I need to count the number of contracts in a column that have a BLANK contract status. I'm counting the Contract Amount column but don't need to sum it. Here's the formula I've started: =COUNTIFS({Contract Amount}, ISBLANK({Contract Stat…
    Accepted
    22 7
    Accepted Answer 22 views 7 comments Most recent by Nick Allgauer
  • Reminder: Request to join Smartsheet Account
    In Using Smartsheet
    Hi, I am the system admin of smartsheet in my organisation, using business plan account. I have invited some of my colleague as free collaborators to view the sheet. The free users know they only need to view and never request for licens…
    Answered - Pending Review
    17 1
    Answered - Pending Review 17 views 1 comment Most recent by Mark Cronk
  • Managing permissions for sheets that will be updated via reports
    In Using Smartsheet
    Hi, I have a sheet that I want users to update using a report. It would be best not to open the sheet up to the full universe of users, but new users are added frequently and I don't want to continually be updating the permissions for th…
    Answered - Pending Review
    10 1
    Answered - Pending Review 10 views 1 comment Most recent by Mark Cronk
  • Select Specific Rows in a Report to create a Chart
    In Using Smartsheet
    Creating a chart in a dashboard: Sourcing data from a Grid sheet you can select, i.e. Row 4, 5, 6 BUT if you are sourcing from a Report, then you can NOT select ONLY rows 4, 5, 6 for example. Smartsheet automatically selects ALL rows in th…
    Answered - Pending Review
    28 4
    Answered - Pending Review 28 views 4 comments Most recent by Thiago Castro
  • Sending empty report
    In Using Smartsheet
    Hello, i have a question about reports. i have a sheet with tracking of my manufecturing per customer and i generate a report for status per customer. and every week on Sunday ths system send via email the reports in EXCEL format. my ques…
    Answered - Pending Review
    7 1
    Answered - Pending Review 7 views 1 comment Most recent by Andrée Starå
  • Looking for a report that allows resources to view all tasks assigned to them on Multiple Sheets
    In Using Smartsheet
    Ability to view and update tasks across multiple projects in one view by Resource, i.e. the person assigned to the task. Resources have tasks in multiple projects. Thanks, GCA
    Accepted
    34 6
    Accepted Answer 34 views 6 comments Most recent by Andrée Starå
  • Internal Employee Merch Shop?
    In Using Smartsheet
    Hello, I have been asked to create an Employee Merch Shop of sorts. The ask is to create an on going place where employees can order (they don't have to pay) for company attire. There is a variety of choices including, company t-shirts, h…
    Answered - Pending Review
    16 2
    Answered - Pending Review 16 views 2 comments Most recent by Mark Cronk
  • Can I conditional format specific cells only?
    In Using Smartsheet
    I only want the rows under my "STATUS" parent row to change colors. If status is less than 0, turn red. If 0 or greater, turn green. I figured out a workaround, but it's still turning other numbers in the column green. If I tr…
    Accepted
    29 2
    Accepted Answer 29 views 2 comments Most recent by Lloyd Kim