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
-
Counting Duplicates using a FormulaAccepted AnswerAccepted Answer KMan1190 20 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 03/24/20,Last post 03/25/20Trying to use COUNTIF to count how many times the values listed in Name Helper are listed in that column. IE see screenshot below. Id like a formula to automatically display the number 1 in the Column called "How Many Active Episodes…Formulas and Functions203KMan1190 -
Multiple IF statementsAccepted AnswerAccepted Answer Katie Mueller 15 views 4 comments 0 points Most recent by Katie Mueller Formulas and FunctionsFirst post 03/25/20,Last post 03/25/20I am trying to get the following to happen, and i am newer to smartsheet so need some help please. I need that if the checkbox in 'row 2' (and under based the amount of entries) is checked AND the Lessons Complete in the first row is starr…Formulas and Functions154Katie Mueller
-
Missing columns on XML export of Gantt chartAnswered QuestionFirst post 03/25/20,Last post 03/25/20I have several columns I need to export with my Gantt chart but only the standard Gantt columns seem to export. Every new column I added to the Gantt chart does not export. I even re-loaded the XML back into Smartsheet and the data is m…Using Smartsheet112Phil Schmitt
-
Need a formula that will send out a reminder if an update has not been received in 7 daysAnswered QuestionAnswered Barb Celic 13 views 1 comment 0 points Most recent by jpagan03101416 Formulas and FunctionsFirst post 03/25/20,Last post 03/25/20Hi all, I'm pretty new to smartsheet, so thanking you in advance for any assistance you can provide. I'm looking for a formula that will send out a reminder if an update request has not been received after 7 days. Here's the scenario. I ha…Formulas and Functions131Barb Celic
-
Edit SubmissionsAnswered QuestionFirst post 02/10/20,Last post 03/25/20Is it possible for a user to retrieve a pre-filled form with their old submission if they want to change something?Using Smartsheet188Jeff McFarland
-
formula questionAnswered QuestionFirst post 03/25/20,Last post 03/25/20Hi, Please can you assist with a formula for the attached image. So if the induction column has "Yes" and Presentation column has "Yes" then the complete column should state "Yes". I'd like this formula to be…Formulas and Functions103sahilhq
-
vlook upAnswered QuestionFirst post 03/25/20,Last post 03/25/20Hi, I'd like assistance in creating a vlook up formula. So I would like the sheet to vlook up and find the date of birth and postcode from a different sheet when the name matches. See attached image of how the sheet where the vlook up nee…Formulas and Functions91sahilhq
-
Datamesh - way to transfer only parent row to sheet?Answered QuestionAnswered KellyAnne Brophy 22 views 1 comment 0 points Most recent by Nathan Lloyd Premium Apps and IntegrationsFirst post 03/18/20,Last post 03/25/20Hi all, I'm currently experiencing an issue when I try to DataMesh a Pivot Table to an existing spreadsheet. My Pivot Table is my Source Sheet, and I use the existing spreadsheet as my Target Sheet. The Pivot Table is set up where each r…Premium Apps and Integrations221KellyAnne Brophy
-
Nested IF giving me an Unparseable errorAnswered QuestionAnswered Jennifer Tillman 61 views 17 comments 0 points Most recent by Jennifer Tillman Formulas and FunctionsFirst post 02/27/20,Last post 03/25/20I am trying to create buckets of product go-live dates using the Nested IF formula. When I only had 4 buckets, it worked perfectly. When I added 3 more buckets, I cannot get it to work. Here's the formula: =IF([Workdays to Go-Live Targe…Formulas and Functions6117Jennifer Tillman
-
Accepted Answer Rebecca Lane 18 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 03/24/20,Last post 03/25/20https://us.v-cdn.net/6031209/uploads/031/I7CRYLLA49U6.png I am trying to set-up a formula, so if there is a duplicate in the Family ID column, the box becomes checked in the Duplicate column. So far, during the searching I have done for o…Formulas and Functions183Rebecca Lane
-
ODBC data pulls US date to mail mergeAccepted AnswerFirst post 03/23/20,Last post 03/25/20I am pulling information into a Microsoft Publisher label template from Smartsheet using ODBC smartsheet live data connector - this all works fine but any columns that are formatted in smartsheet as date columns are switched from UK format…Using Smartsheet151PeterR
-
Link Data in a Smartsheet on a Specific Day and Make StaticAnswered QuestionFirst post 03/25/20,Last post 03/25/20I have several 13 Smartsheets that make up a campaign of projects. At the top of each sheet I have some metrics, including the % complete for all the projects, combined, on the Smartsheet. I want to create a new Smartsheet that links dat…Formulas and Functions82Donna T
-
Not allowing me to share Dynamic ViewAnswered QuestionAnswered Michael Heisler 41 views 3 comments 0 points Most recent by Michael Heisler Premium Apps and IntegrationsFirst post 01/03/20,Last post 03/25/20Hello, I am trying to add people under shared users but it only only has a limited number of names and it wont let me add in any outside of that list. What could be causing this? Thank you https://us.v-cdn.net/6031209/uploads/604/OM3OZ0K…Premium Apps and Integrations413Michael Heisler
-
Fail to get data from tableauAnswered QuestionFirst post 03/24/20,Last post 03/25/20Hi everyone, I tried to create a widge on dashboard with the data from Tableau, Unfortunately failed. The error message is below. I did pasted the tableau link starting with https://. However it didn't work.. Would you help to check the p…Using Smartsheet81峰(Frank) 徐(Xu)
-
Dual Axis Card viewAnswered QuestionFirst post 02/11/20,Last post 03/25/20We love the card view for our use case, but we would love to be able to further subdivide the view somehow if possible... We don't want to have to create a specific filter for each person associated with a project, but we want to be able t…Using Smartsheet273jay.rathbun
-
First post 03/23/20,Last post 03/25/20I have a checkbox column "Inv 3rd Party Vendor." I am needing to index a master sheet with all of our property names, and look to see if the "inv 3rd party Vendor" box is checked in that sheet. If it is, I need it to ch…Formulas and Functions2917steve50951
-
Can smartsheet report who checked a checkboxAnswered QuestionFirst post 03/25/20,Last post 03/25/20Dear Mr/ Ms, I'm looking for ways to organize document control in Smartsheet through check boxes if/when documents are revised by colleagues. I'm looking for a way to 'check' a box, and then in another collumn(s) report who checked the bo…Formulas and Functions131Tomas Giele
-
First post 08/19/19,Last post 03/25/20Hello - I reached out to Smartsheet a few times about Dynamic View as I want to see if it fits my needs. I didn't have a good experience with the Sales team. I had a meeting that was entirely missed. I was told an Engineer needs to be at t…Using Smartsheet493NBurrus -
Nested if for FLAG columnAccepted AnswerAccepted Answer Daniel Child 23 views 2 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 03/24/20,Last post 03/25/20I am trying to build a nested if for a flag column and cannot get my brain around the final piece of the statement. Basically I am trying to create a function that looks at a 3 variables: (1) Date column and if it is not blank and (2)the …Formulas and Functions232Daniel Child
-
Accepted Answer SuzanneH 39 views 10 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 12/30/19,Last post 03/25/20I have a form entry sheet where I have some columns hidden but defaulting to a formula. The goal is to have the columns populate with the results of the formulas without any updates required (like cutting and pasting the formula in the gr…Formulas and Functions3910SuzanneH
-
First post 02/10/20,Last post 03/25/20I need to send out a client survey every 2 weeks to 5 different stake holders. Is there a way to automate the "Send Link to Form" option in the "More" drop down under "Edit Forms" to send just the link to the…Using Smartsheet273Cheryl Crouse
-
Seemingly simple formula will not workAnswered QuestionFirst post 02/12/20,Last post 03/25/20I have a parent cell that should be looking at its children for a value, and if it finds that value in any of the children, it should display that value in itself, else nothing. This seems pretty straight forward, but it's not working. It …Formulas and Functions344siouxzie7
-
Linking a One Drive Folder to SmartsheetAnswered QuestionFirst post 03/13/20,Last post 03/25/20I need to provide my users with a link to a One Drive folder where all of the project documents will be stored (and eventually attached in Smartsheet). I don't particular want to have to send the link in an email. Is it possible for the …Using Smartsheet193sbrelage
-
Embed Weather widgetAnswered QuestionFirst post 02/19/20,Last post 03/25/20Is there any way to embed a link on my dashboard that will reflect the current weather in our area?Using Smartsheet343kk -
Allow updates on demand rather than using weekly automationAnswered QuestionAnswered Shawn Borror 15 views 3 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 02/11/20,Last post 03/25/20Is there an ability to allow not SS users the ability to update their assigned data elements on demand or does it have to be done via a workflow that runs on time based? Many legal team members need to update on demand for legal 'tickets'…Formulas and Functions153Shawn Borror
-
Restricting User "view"Answered QuestionAnswered lauren.waters111676 42 views 12 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 01/02/20,Last post 03/25/20I am setting up a sheet that will intake applications to employment positions. it would be very cumbersome to create a separate sheet for each position we have posted. Rather, I'd like all applications to go into one sheet, and then filter…Using Smartsheet4212lauren.waters111676
-
It's possible to create clone sheet of my main sheet.Answered QuestionFirst post 03/23/20,Last post 03/25/20i want to create 2 dynamic sheets based on same input. but some columns might be visible. so i will create separate view or any clone / copy paste options are available.API & Developers214Yashwant Singh
-
First post 03/21/20,Last post 03/25/20Hi, I created a form to collect survey results, the responses are returned to Smartsheet #1 (image below). The survey has 18 questions with these dropdown (single select) responses: Good Satisfactory Does Not Meet Standards Not applicable…Formulas and Functions357Amy Arnold
-
Sum Column results when filteredAccepted AnswerAccepted Answer Mitchell Moses 11 views 1 comment 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 03/25/20,Last post 03/25/20I want to sum numbers in a column of all the vendors. If I filter out certain vendors I want the sum to be only of the vendors showing. How do I do that?Formulas and Functions111Mitchell Moses
-
Forms with Duplicate EntriesAnswered QuestionFirst post 02/26/20,Last post 03/24/20I have a sheet where I am collecting specific account information, but then want to collect names and demographic for multiple people. Is there a way to only input the account information once, but then have multiple rows with individual …Using Smartsheet285S_Karkhoff
