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 Question
    In Formulas and Functions
    I have two smartsheets. One contains my budget and one contains budget vs actual. Currently, Im using an index function to find the budget for the month of each cost account BUT every month I have to go update the column index in the funct…
    Answered - Pending Review
    28 10
    Answered - Pending Review 28 views 10 comments Most recent by Cristina Andersen Formulas and Functions
  • Max out Cross sheet reference ?
    In Using Smartsheet
    I have an error message "unable to create cross sheet reference because this sheet already contains the maximum number of different cross sheet references."  How to resolve this issue? I already deleted many rows to reduce the c…
    36 10
    Accepted Answer 36 views 10 comments Most recent by Lynna Using Smartsheet
  • Sheet Sharing Problem
    In Using Smartsheet
    I've shared a report from a Workspace with collaborators (not licensed) and the report only shows them a blank template. All information from the master sheet is missing. What is causing this? I also tried creating a copy of the report …
    12 3
    Accepted Answer 12 views 3 comments Most recent by Paul Newcome Using Smartsheet
  • SUMIFS and Contains
    In Formulas and Functions
    I'm trying to use SUMIF with CONTAINS using: =SUMIF([Payment Amount]2:[Payment Amount]3, CONTAINS("FY20", [Date Paid QFY]2:[Date Paid QFY]3), [Payment Amount]2:[Payment Amount]3) But I'm getting a 0 result. Note that Date Paid Q…
    Answered - Pending Review
    16 3
    Answered - Pending Review 16 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Counting cells with multiple selections and criteria
    In Using Smartsheet
    HI- I'm trying to count the cells for the developer (1st criteria) and priority (2nd criteria) which sometimes has multiple selections. It is only pulling counts for those cells that have one option selected. I need for it to pull coun…
    Answered - Pending Review
    16 1
    Answered - Pending Review 16 views 1 comment Most recent by Paul Newcome Using Smartsheet
  • Zero Formula
    In Formulas and Functions
    Where do I find the formula to have a cell display nothing when the total becomes the number zero? I have a sheet with zeros in multiple places and it clutters to much. 
    Answered - Pending Review
    763 15
    Answered - Pending Review 763 views 15 comments Most recent by Paul Newcome Formulas and Functions
  • Unable to Edit 1 Column on a Spreadsheet
    In Using Smartsheet
    Hello all, I am working on a collaborative spreadsheet on which I am an administrator. All I am trying to do update a vlookup function for one column, which references a different spreadsheet, on which I am also an administrator. The spre…
    15 1
    Accepted Answer 15 views 1 comment Most recent by KDM Using Smartsheet
  • Limit the number of entries on a form
    In Using Smartsheet
    I am trying to use a form to collect registration for an event. There is a limited number of attendee spots at the event. Is there a way to shut off the form after 100 entries? I could only find old posts on this and was hoping an update h…
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by [email protected] Using Smartsheet
  • Pivot updates and charts in a dashboard
    In Premium Apps and Integrations
    I have a pivot sheet with all of the data formatted the way I need it but when it refreshes it pulls columns back in that are not needed which impacts a chart within my dashboard. Any suggestions? Thank you.
    10 0
    Question 10 views 0 comments Started by asimone Premium Apps and Integrations
  • if formula help
    In Formulas and Functions
    I am trying to do a formula that states: if there is text in the column2 then place a "1" in the primary column. @Paul Newcome
    Answered - Pending Review
    16 4
    Answered - Pending Review 16 views 4 comments Most recent by Mike Wilday Formulas and Functions