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 QuestionIn Formulas and FunctionsI 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 views 10 comments 0 points Most recent by Cristina Andersen Formulas and Functions
-
Max out Cross sheet reference ?In Using SmartsheetI 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…
-
Sheet Sharing ProblemIn Using SmartsheetI'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 …
-
SUMIFS and ContainsIn Formulas and FunctionsI'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 views 3 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Counting cells with multiple selections and criteriaIn Using SmartsheetHI- 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…
-
Zero FormulaIn Formulas and FunctionsWhere 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 views 15 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Unable to Edit 1 Column on a SpreadsheetIn Using SmartsheetHello 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…
-
Limit the number of entries on a formIn Using SmartsheetI 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 views 1 comment 0 points Most recent by [email protected] Using Smartsheet
-
Pivot updates and charts in a dashboardIn Premium Apps and IntegrationsI 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.
-
if formula helpIn Formulas and FunctionsI am trying to do a formula that states: if there is text in the column2 then place a "1" in the primary column. @Paul NewcomeAnswered - Pending Review 16 views 4 comments 0 points Most recent by Mike Wilday Formulas and Functions