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

  • #Invalid Data Type for identical formula on one sheet that works on another sheet
    In Formulas and Functions
    Hello, I have two identical sheets to collect application data, each for a different project type. We'll call them Sheet 1 and Sheet 2. They both reference the same budget request sheet. I have a "Budget Submitted" column on each…
    Answered - Pending Review
    20 2
    Answered - Pending Review 20 views 2 comments Most recent by KDM Formulas and Functions
  • Limiting Values Visible in Form/Dynamic View Fields?
    In Premium Apps and Integrations
    Given a column that uses a series of predefined dropdown values, is it possible to specify which of these may be selected from a Form or from a field within a Dynamic View? I don't want to present all options to users.
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Sean Morgan Premium Apps and Integrations
  • Calendar App
    In Premium Apps and Integrations
    Hi! I'm new to the Calendar App. I was wondering if there is a way to show time blocks on the calendar. When I send to iCal to view in Outlook, everything shows up in the banner meaning everything is an all day event when it isn't. Not …
    Answered - Pending Review
    20 1
    Answered - Pending Review 20 views 1 comment Most recent by Sean Morgan Premium Apps and Integrations
  • URGENT Need for help
    In Using Smartsheet
    Hello all, I understand this might not be the real place to ask my question, but am stuck and in need of help. My scubscription ends in a few days, and I am having trouble chenging my credit card details on smartsheet site. I have alre…
    Unanswered
    14 0
    Question 14 views 0 comments Started by Eid E. Eid Using Smartsheet
  • Global Automation Permissions?
    In Formulas and Functions
    Are there global automation permissions, where the Limited option can be set across the board? All I could find was Permissions in Security & Controls. For any new sheet created, I want to default the Automation Permissions setting to …
    Accepted
    12 2
    Accepted Answer 12 views 2 comments Most recent by Kyle Chipman Formulas and Functions
  • Report not filtering out all 100% complete tasks
    In Using Smartsheet
    I have a report to show me all of the tasks that are in progress (not 100% complete) or not started within a timeframe. Therefore, the report is supposed to filter OUT all tasks that at 100% complete. It has been working for over two year…
    53 views 4 comments Most recent by JeremiahHorstick Using Smartsheet
  • Last Week's Value
    In Formulas and Functions
    Hi All, Does anyone know of a formula that can pull the values from an existing column from the week prior using the cell history or activity log? e.g. I can see the value last week in the cell history but I want to pull it automatically…
    Answered - Pending Review
    13 2
    Answered - Pending Review 13 views 2 comments Most recent by JeremiahHorstick Formulas and Functions
  • Email to Smartsheet to create new row in Sheet
    In Using Smartsheet
    I'd love to have a discreet email address tied to a sheet so that I could forward it emails as a way to create new tasks. I can't get force people to use a form so it would sure be handy to just set a rule that forwards to an email address…
    Answered - Pending Review
    13 1
    Answered - Pending Review 13 views 1 comment Most recent by JeremiahHorstick Using Smartsheet
  • What's wrong with my formula?
    In Formulas and Functions
    =COUNTIFS(Position2:Position196, CONTAINS("Medical Assistant", @cell), [Cleared to Return?]2:[Cleared to Return?]136, OR(CONTAINS("No", @cell), CONTAINS("Contingent", @cell)))
    Answered - Pending Review
    19 2
    Answered - Pending Review 19 views 2 comments Most recent by Mike Wilday Formulas and Functions