Recent Discussions
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
-
Announcement Stephanie Boulanger 48 views 0 comments 0 points Started by Stephanie Boulanger AnnouncementsFirst post 05/27/20,Last post 05/27/20Thanks to all who joined us for our "Ask Me Anything" session with Dan Bloom! We had a lot of great questions and look forward to hosting more of these sessions in the coming months! Missed the session? Please read the below to …Announcements480Stephanie Boulanger -
Announcement Stephanie Boulanger 58 views 0 comments 0 points Started by Stephanie Boulanger AnnouncementsFirst post 05/18/20,Last post 05/18/20Our new marketing community group is live! Connect and collaborate with your fellow marketers, get your questions answered, gain access to marketing-specific content and events, and share your marketing expertise and know-how. To learn …Announcements580Stephanie Boulanger
-
First post 09/12/19,Last post 05/31/20What other options do we have to format the sheet better, perhaps even in sections? Merging some cells will help get rid of the lines and make things look better spacing wise.Using Smartsheet344beatea -
First post 05/31/20,Last post 05/31/20Hi, I'm tracking an estimated Start and End date (in a Project Sheet) and an Actual Start and End date (in a tracking sheet). In both sheets the rows where the dates are entered are CHILDREN and they both have an Asset # that I'm can match…Formulas and Functions40Jeana
-
First post 05/31/20,Last post 05/31/20I am building a workflow where I want to trigger an alert when the value in one column is less then the value in another column. How do I do that?Using Smartsheet50Chuck Homola
-
Sum formula not workingQuestionFirst post 05/30/20,Last post 05/30/20Trying to sum cells in a row that have value based on a formula. I've read that this can be an issue and to use VALUE in the equation. However, I'm still getting a RED Zero as a result. Any ideas? =VALUE(SUM([Printing and Shipping]7, [Int…Using Smartsheet40Jeana
-
How do I show health based on end date & % complete?Accepted AnswerAccepted Answer Michelle Vidal 11 views 2 comments 0 points Most recent by Michelle Vidal Formulas and FunctionsFirst post 05/29/20,Last post 05/30/20I'm trying to show health of a project based on how far out from End date + how much of the work has been completed. Green: 100% complete before or on End date Yellow 70-99% and today is < 1 range of End Date <69% and date within 2 …Formulas and Functions112Michelle Vidal
-
New to this...please help...QuestionFirst post 05/30/20,Last post 05/30/20Please help. I keep getting #unparseable error for the following formula: =IF(OR([DLExpiration Date]1 > TODAY(); [MECExpiration Date]1 > TODAY()); "NON COMPLIANT"; "COMPLIANT") I want the cell in my Status column…Formulas and Functions80Lisa Rogers
-
Can I use @row in this formula?Accepted AnswerFirst post 05/08/20,Last post 05/30/20=IFERROR(COUNTIFS([Expected Close Date]:[Expected Close Date], YEAR(@cell) = 2020, [Sales Stage]:[Sales Stage], "A"), "Check for 'Blanks' in Forecast, Probability or Close Date") =IFERROR(COUNTIFS([Expected Close Date…Using Smartsheet2712Jason Wirl
-
Answered - Pending Review Samuel Dowdy Jr 10 views 1 comment 0 points Most recent by Sean Morgan Formulas and FunctionsFirst post 05/29/20,Last post 05/30/20Sheet --> https://app.smartsheet.com/sheets/Rp5CHm6mFGcw2CG7x8rFjmfGwVpG394xffJw2x91 I really need some help placing data throughout this sheet by using formulas. I know what I want but I dont know the formulas. I want the total mont…Formulas and Functions101Samuel Dowdy Jr
-
Predecessor Plus One YearQuestionAnswered - Pending Review Ezra 14 views 1 comment 0 points Most recent by Sean Morgan Formulas and FunctionsFirst post 05/28/20,Last post 05/30/20I've been using 52 weeks (for example: 17FF + 52w) to give me a 1 year warranty expiration date from the end of the project gantt. It would be nice to have a full year option, like this: 17FF + 1yFormulas and Functions141Ezra -
SumProduct and CountifQuestionAnswered - Pending Review Jesus-LLTK 35 views 1 comment 0 points Most recent by Sean Morgan Formulas and FunctionsFirst post 05/27/20,Last post 05/30/20I need help trying to count the total matches in two ranges with a criteria. I don't have this problem with Excel using the following formula method. =SUMPRODUCT(COUNTIFS(C1:C5000,J1:J9,D1:D5000,"Customer 1")) What i'm doing is …Formulas and Functions351Jesus-LLTK
-
First post 05/30/20,Last post 05/30/20Hi, I have about 80+ projects running simultaneously. In each project sheet, I have some basic project information & metrics (duration of each milestone calculated from actual start & finish dates) which needs to be tracked and ana…Using Smartsheet60Abhiraj Joshi
-
First post 04/22/20,Last post 05/30/20My workflow requires rows to get moved and copied throughout each department. Is there anyway to define what columns that get moved over. I'm having hide many columns through each department because they only need to see certain informatio…Formulas and Functions152ginamt3
-
Average formulaAccepted AnswerAccepted Answer Deanna Vandermeer 24 views 19 comments 0 points Most recent by Deanna Vandermeer Formulas and FunctionsFirst post 05/27/20,Last post 05/30/20I am sure this is rather obvious, however I am not seeing where my mistake is. All I am trying to do is return the average cost of a product cost column but I need to not include any $0.00 dollar amounts that are populating (which will hap…Formulas and Functions2419Deanna Vandermeer -
how to get ° degrees circle symbol in a cellAccepted AnswerAccepted Answer Lisa_Doris 13 views 3 comments 0 points Most recent by Lisa_Doris Formulas and FunctionsFirst post 05/28/20,Last post 05/30/20How do I write the degree symbol and is there a sheet with all symbol shortcuts available somewhere, not just the most popular?Formulas and Functions133Lisa_Doris
-
Answered - Pending Review Vivien Chong 19 views 4 comments 0 points Most recent by [email protected] Formulas and FunctionsFirst post 05/28/20,Last post 05/30/20I need a formula to calculate the week number for the month, for example 28 May 2020 is the 5th week of the month. I understand that week number calculate from w1 - w52. How can I calculate the week number for the month? So basically, the …Formulas and Functions194Vivien Chong
-
[email protected]23 19 views 6 comments 0 points Most recent by [email protected] Formulas and FunctionsFirst post 05/28/20,Last post 05/30/20So apparently smartsheet created and modified columns retain time down to at least the seconds, I wasn't willing to keep checking beyond that. I utilized this to report the time difference in form submissions down to the seconds. Just shar…Formulas and Functions196[email protected]
-
First post 05/30/20,Last post 05/30/20I am having trouble getting this formula right. I want to pull the qty of flooring scheduled to run in a given week (1-52) provided it requires one of 2 types of veneer. (Acacia 1220x077x1.5 or Acacia 1220x185x1.5) https://us.v-cdn.net/60…Formulas and Functions80Devin Barta
-
Answered - Pending Review Jeana 15 views 4 comments 0 points Most recent by Jeana Formulas and FunctionsFirst post 05/29/20,Last post 05/30/20So I have a drop down column with options from 1--3. Each has a description similar to this: Priority 1 - Nice to have 2 - Needed 3 - Required I would like to total the actual number that is selected in a row below these options (then I'l…Formulas and Functions154Jeana
-
Workaround for broken UTC System Created Date ColumnAccepted AnswerAccepted Answer ScionoftheNight 15 views 6 comments 0 points Most recent by Werner Gerstacker Formulas and FunctionsFirst post 05/29/20,Last post 05/29/20Hi, my problem is the same as in https://community.smartsheet.com/discussion/19461/wrong-date-showing-seems-to-be-4-hours-off-the-difference-between-gmt-and-my-time-zone In short, I am on GMT-7 time, while Smartsheet operates under UTC. B…Formulas and Functions156ScionoftheNight -
Answered - Pending Review courtneyjenkins8 13 views 1 comment 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 05/29/20,Last post 05/29/20When "Connect Done" and "Core/Micro Done" are both checked, I want "Client Done" to automatically be checked. Can someone help me with the formula? I'm guessing its an =IF https://us.v-cdn.net/6031209/uploads/…Formulas and Functions131courtneyjenkins8
-
Count Up TimerQuestionFirst post 05/29/20,Last post 05/29/20Hey all. Brand new (3 days) Smart Sheet user. I am working on an exercise with my team and would like to have a running "count up" timer (stop watch if you will) in a dashboard that shows from the time we kicked off to where we a…Using Smartsheet60Jaison Scott
-
Answered - Pending Review Sandy Challman 12 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/29/20,Last post 05/29/20I thought I was in a Report. BUT I was in a filter and I deleted several columns from a sheet. I do not have a backup. In the recent history it will not show the data in the columns either. HELP!Using Smartsheet121Sandy Challman
-
Publishing and Google Search indexing and crawlingAccepted AnswerFirst post 02/11/20,Last post 05/29/20Business and Enterprise users can publish a sheet, report, or dashboard. My question is can these pages be discovered by Google Search indexing and crawling? These are the options I refer to: https://us.v-cdn.net/6031209/uploads/838/W1JO7W…Using Smartsheet697Mary_A
-
Writing a formula to count criteria in a multi-select columnAccepted AnswerAccepted Answer Iris Riddell 17 views 7 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 05/01/20,Last post 05/29/20Hi everyone! Newcomer to Smartsheet here. I work for a small family wellbeing agency and I'm trying to write a formula to tally up the criteria provided for why someone is applying/being referred for one of our programmes. We have "Se…Formulas and Functions177Iris Riddell
-
How to create a weekly/monthly reportAccepted AnswerAccepted Answer Beronica Muller 76 views 21 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 04/17/20,Last post 05/29/20Hello, I need assistance with creating a formula to produce a weekly and monthly report from my Smartsheet? I will need to provide a weekly report containing total number of request received for the week, also how many were completed, stil…Formulas and Functions7621Beronica Muller
-
Answered - Pending Review Jessy Martin 9 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/29/20,Last post 05/29/20Can I set up an automation based on a field in a sheet summary? What I'm ultimately trying to do is set up a review/approval workflow for an entire spreadsheet. Everything I've tried so far (adding status column to the sheet, using a sepa…Using Smartsheet91Jessy Martin
-
How do you create a Sum if equation when the criteria is based on a value in a Multi-Select ColumnQuestionAnswered - Pending Review Andrea Hill 9 views 1 comment 0 points Most recent by Werner Gerstacker Formulas and FunctionsFirst post 05/29/20,Last post 05/29/20When I chose just one of the selections (I have been using "Product" no" = "or other signs) it only sums the values were there is only "Product" . the equation wont sum if there are other selections included.Formulas and Functions91Andrea Hill
-
Answered - Pending Review jeflanne 20 views 2 comments 0 points Most recent by cfavron103911 Using SmartsheetFirst post 05/26/20,Last post 05/29/20How do I auto populate a column when a new row is added?Using Smartsheet202jeflanne
-
Question Carolina Rivera 9 views 0 comments 0 points Started by Carolina Rivera Formulas and FunctionsFirst post 05/29/20,Last post 05/29/20Hi! So I'm trying to create a stacked bar graph using two sets of data. Data set 1 has actions that are divided by months, for example, the month of May has 5 actions, while the month of June has 3 actions. Data set 2 has the same actions,…Formulas and Functions90Carolina Rivera -
First post 04/23/19,Last post 05/29/20I am trying to find the average of checkboxes in a row. At row: "Clear pads as needed..." I want the % to add up as each box is checked. What is the formula? Appreciate the help. (Image)Formulas and Functions304JennS_
