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
-
Join us tomorrow at 10 a.m PDT for our “Ask Me Anything” with marketing expert- Dan Bloom!AnnouncementAnnouncement Stephanie Boulanger 15 views 0 comments 0 points Started by Stephanie Boulanger AnnouncementsFirst post 05/27/20,Last post 05/27/20Join us tomorrow, May 28, at 10 a.m. PDT in our NEW marketing group for our “Ask me anything” session with Dan Bloom - marketing expert, cofounder of Slope and Director of Strategic Solutions here at Smartsheet. Dan will be here to share …Announcements150Stephanie Boulanger -
Announcement Stephanie Boulanger 51 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 …Announcements510Stephanie Boulanger
-
VLOOKUP FOR 160+ COLUMNSQuestionAnswered - Pending Review Archie Villa 2 views 1 comment 0 points Most recent by Archie Villa Formulas and FunctionsFirst post 05/28/20,Last post 05/28/20Hello Everyone I have created a form with 160+ questions in it then it was summarized in sheets ( see attached "FORM.png") Now that i have those answers , i want them to be summarized in another sheet in rows since the answers ha…Formulas and Functions21Archie Villa -
First post 05/28/20,Last post 05/28/20Hello Smartsheet experts! I have a question that I am hoping you can assist with. I am attempting to build the back-end for a Dashboard widget that displays the top 10 occurrences of a text name that is pulled from the "Name" col…Formulas and Functions40Sese Bennett
-
First post 05/28/20,Last post 05/28/20estoy usando la de muestra pero quiero pagar un mes plan individual pero no me permiteUsing Smartsheet20Darwin Enriquez
-
Circular ReferenceQuestionAnswered - Pending Review Ray B 5 views 1 comment 0 points Most recent by Ray B Formulas and FunctionsFirst post 05/27/20,Last post 05/27/20Smartsheet Community How do I SUM this formula with in the Same Row without Receiving a Blocked or Circular Reference? Row17: IFERROR(Passed17 / $[Total Test Cases]$17, 0) Row 18:Is a Sum within the same Column as Row 17 =SUM(Passed18:Def…Formulas and Functions51Ray B
-
Average formulaAccepted AnswerAccepted Answer Deanna Vandermeer 8 views 2 comments 0 points Most recent by Deanna Vandermeer Formulas and FunctionsFirst post 05/27/20,Last post 05/27/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 Functions82Deanna Vandermeer -
Metric Sheet or Sheet Summary?QuestionFirst post 05/27/20,Last post 05/27/20Could someone explain the differences and benefits of using a metric sheet or a sheet summary? I have a project that has several grids, reports, and dashboards, and I need to add some metrics from the grids into a dashboard. I have created…Formulas and Functions40Lee Ratzlaff -
Accepted Answer Syed Mohd Muhafzal 9 views 2 comments 0 points Most recent by Syed Mohd Muhafzal Formulas and FunctionsFirst post 05/27/20,Last post 05/27/20Hi Smart Community, I am trying to Sum my CHILDREN() Countif but it is not giving any value. All my sub-children is indicated as flag (1 or 0) Example When there is a delay release in a category Bug Fix : it will flagged out RED. On Bug Fi…Formulas and Functions92Syed Mohd Muhafzal
-
caroline_allen37286 166 views 11 comments 0 points Most recent by Meagan Harte Formulas and FunctionsFirst post 02/12/18,Last post 05/27/20I love the new VLOOKUP functionality and am using it to try to reference IMAGES that I have stored in another sheet.However, I noticed that SmartSheet only pulls in the image name (example: imagename.jpg) and does not actually show the ima…Formulas and Functions16611caroline_allen37286
-
Answered - Pending Review A. Marcus 16 views 4 comments 0 points Most recent by A. Marcus Formulas and FunctionsFirst post 05/21/20,Last post 05/27/20Hey all, I'm relatively new to Smartsheets and am hoping someone can help me out. I promise I've looked everywhere for an answer and I think I'm making this more complicated than it is. Thanks in advance for the guidance! I have a sheet …Formulas and Functions164A. Marcus
-
Answered - Pending Review Jörg Schmidt 9 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/27/20,Last post 05/27/20Hallo, is it possible to put an automatic signature into "Email formula" when I send an update requestUsing Smartsheet93Jörg Schmidt
-
First post 05/28/18,Last post 05/27/20Hello, I have creeated an online form but I need that people can add an attachment (image). Anyone knows if this is possible and how? I guess it is possible as this form I am filling in has this feature. Thanks you for your help Ugo …Using Smartsheet66610ugo.quaglino49201
-
First post 05/27/20,Last post 05/27/20We have a newsletter that gets sent out, and tracks if anyone opens or clicks through them. That Excel file is uploaded to Smartsheet. We then follow up with anyone who interacted with the newsletter, and follow ups are tracked with commen…Formulas and Functions50Nick Winkley -
First post 05/22/20,Last post 05/27/20Greetings I some how got the background of one of my smartsheets to appear gray whenever I create a new column and when I pull a report and display the Sheet Name (system column) it too appears to be gray. I have doubled checked the condi…Using Smartsheet184Ty Layton
-
First post 05/27/20,Last post 05/27/20I know this question likely goes against all that is Smartsheet, but... We have a sheet setup to take submissions from a form. When a new row is added, a contact in a column is notified. After the row's status is still "in progress&…Formulas and Functions50Donna T
-
Project look aheadAccepted AnswerAccepted Answer John Kelly 11 views 4 comments 0 points Most recent by John Kelly Formulas and FunctionsFirst post 05/26/20,Last post 05/27/20Hi, I am looking to add a widget to a dashboard to show a two week look ahead of a project. I have a project sheet and essentially want to create a formula to check a box, from which I can use to trigger a report.Formulas and Functions114John Kelly
-
How to create a top five.QuestionFirst post 05/27/20,Last post 05/27/20Hi! I've working on a dataset for a while now that essencially logs the everyday orders we receive from our clients. One of the colums records the name of the customer and I've been trying to create a report that counts how many orders a …Using Smartsheet100Javier
-
First post 07/24/18,Last post 05/27/20Hello, To make our Smartsheets more legible when used for input requests, we use conditional formatting. For example, if we have a table used for percentage-splits with 12 columns and 100 rows we generally pre-populate these inputs wher…Using Smartsheet2613Wouter Hijzen
-
Multiple Criteria, total countQuestionAnswered - Pending Review Mona Singh 10 views 4 comments 0 points Most recent by Mona Singh Formulas and FunctionsFirst post 05/27/20,Last post 05/27/20Hi All, I am trying to do calculate a total number of events, that match criteria for 1. Date range (can also use fiscal column as a matching criteria where i only want those that contain specific letter/numerical value = Q2) for all -ND…Formulas and Functions104Mona Singh
-
Answered - Pending Review jpagan03101416 18 views 2 comments 0 points Most recent by Jon Baier Premium Apps and IntegrationsFirst post 04/16/20,Last post 05/27/20For some reason the calendar App in web or is not working correctly. I have attached a screenshot of the web and a PDF export (PDF is working how is supposed to) Web Version https://us.v-cdn.net/6031209/uploads/193/TNBXIDDJDDHF.png PDF ver…Premium Apps and Integrations182jpagan03101416
-
First post 05/26/20,Last post 05/27/20Hello. I am trying to put a gantt onto a dashboard. The advantage of using the web content widget is that you can visualize the indented hierarchy and in fact collapse it for a higher level view for some audiences, but expand it when you n…Using Smartsheet131mikeb
-
First post 05/27/20,Last post 05/27/20Is there a setting to change the from field of an automatic alert email. Workflows/automations that I have set up myself always come from "my name via Smartsheet". It has caused some confusion to people receiving these automated …Using Smartsheet120Toni Vohnoutka
-
Reproducible HyperlinksQuestionAnswered - Pending Review Dennis Knipfer 19 views 3 comments 0 points Most recent by Mike Wilday Using SmartsheetFirst post 05/27/20,Last post 05/27/20I'm compiling a hyperlink section to include at the top of project sheets, a little more than a dozen in total. This collection creates my tabbed "Excel report". It will allow end users to navigate to the tabs/sheets they need. I…Using Smartsheet193Dennis Knipfer
-
Updating a Date Column after another cell is updated.Accepted AnswerAccepted Answer Eric Glassey 9 views 3 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 05/27/20,Last post 05/27/20I am trying to have a Date Column update with today's date when a single select option is chosen. I don't want to use the system update date column because that will get updated whenever any cell is selected. For example: I have a single …Formulas and Functions93Eric Glassey
-
SumProduct and CountifQuestionFirst post 05/27/20,Last post 05/27/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 Functions140Jesus-LLTK
-
Answered - Pending Review mkilci 76 views 12 comments 0 points Most recent by [email protected] Formulas and FunctionsFirst post 02/27/20,Last post 05/27/20Hello, I need help simplifying this formula. I need to enter a Quarter based on a date, For example, if the date is Jan 1 2020, enter Q120 in the cell. If April 1 2020 than enter Q220, and so on. I am using this formula, which is making th…Formulas and Functions7612mkilci
-
First post 05/20/20,Last post 05/27/20Doing this so I have an ongoing list of functioning optimized formulas , keeping it in the community in case it helps someone else. Please feel free to comment with your own, but I'm keeping the most basic of the formulas out of this. Bel…Using Smartsheet304[email protected]
-
First post 05/27/20,Last post 05/27/20Now that the forms have had a good update, I would love to be able to add a conditional format OR use the one I have entered in another column. SO THAT the entry would show an error, or out of spec condition. For instance, operator enter…Using Smartsheet120beth_linder28141
-
Answered - Pending Review Paul Kemp 10 views 1 comment 0 points Most recent by Ramzi Using SmartsheetFirst post 05/27/20,Last post 05/27/20Hi there, I can see in resource view, you can see the individual resource utilisation, but can you see a aggregated total per group anywhere, without having to export to excel and adding formula's? Cheers PaulUsing Smartsheet101Paul Kemp
-
Answered - Pending Review Fabian Tiemann 10 views 1 comment 0 points Most recent by Ramzi Premium Apps and IntegrationsFirst post 05/27/20,Last post 05/27/20Dear Ladies & Gents, is there a possibility to filter by using datetime fields in salesforce and compare them to date literals, e.g.: take only records where a datetime field contains a value greater than the current date? Thanks a lot…Premium Apps and Integrations101Fabian Tiemann
-
Answered - Pending Review Jose Rivera 21 views 1 comment 0 points Most recent by [email protected] Formulas and FunctionsFirst post 05/25/20,Last post 05/27/20Hi everyone, I need to use INDEX MATCH formula to get a DS# with a CNDT# in another report. The easy formula would be: =INDEX({DS Report Range 2}, MATCH([CNDT Number]1, {DS Report Range 3}, 0)), "") but the thing is that sometim…Formulas and Functions211Jose Rivera
