Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
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
-
First post 05/17/19,Last post 01/23/20Hey Is it possible to have the the drop-down list of a column changed based on the value of another column? Eg. If column A's value is set to "Work stage 2" column B's drop-down list will have a specific list, but when it is se…Formulas and Functions29916[email protected] -
Auto refresh dropdown listAccepted AnswerAccepted Answer Jerome Szurubura 15 views 4 comments 1 point Most recent by Julian Sindall Formulas and FunctionsFirst post 01/22/20,Last post 01/23/20Is it possible to link dropdown list choice to a specific column in a specific sheet? That would be really helpful to update automatically the dropdown list. Thanks for your supportFormulas and Functions154Jerome Szurubura
-
First post 01/17/20,Last post 01/23/20Hello, I am considering requiring interviewees perform a skill test in Smartsheet as part of the recruitment process. Has another done this? If so, do you mind sharing what you have? Thank you.Using Smartsheet201nskoulphong
-
First post 01/22/20,Last post 01/22/20Are there Portfolio or Program templates that will display tasks in a gantt chart or horizontal timeline view?Using Smartsheet192Sarah Krueger
-
First post 01/15/20,Last post 01/22/20I have rather long project sheets and several standard reports (Over Due Tasks, Tasks Due Next Week, etc) and include "Sheet Name" as a column in all. Each person is active on multiple sheets (projects), so all their assigned &a…Using Smartsheet163poweb048
-
SUM totals of VLOOKUPAccepted AnswerAccepted Answer @SPark 19 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/22/20,Last post 01/22/20Looking for help on a formula. I need the Forecast Adjustment column on (A) to add all amounts pulling (B). These should total $13,416.67, however, it it showing as $5,416.67. Please help! How do I change the formula to sum the VLOOKUPS? …Formulas and Functions193@SPark
-
First post 01/17/20,Last post 01/22/20New user looking for some advice. We need to: Capture requests from a form(s) and save the original data. We know comments and attachments will be made by other users, and we don't want them to mess up what was originally there, or the or…Using Smartsheet375Tom.Richards
-
Help with an IF/AND/OR formulaAccepted AnswerAccepted Answer Jenna Corso 25 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/22/20,Last post 01/22/20Hello, I am trying to write a formula to return today's date when all of the following are met: Column 1 is not blank Column 2 is not blank Column 3 is either Kangaroo or Platypus If any of these is untrue, then I would like the cell to…Formulas and Functions253Jenna Corso
-
First post 01/20/20,Last post 01/22/20I work with large data sets on parts (60,000 SKUs) and I have a form and workflow for processing special pricing requests from our field. I'm curious if I can house the prices on an external excel file or sharepoint and pull in the pricing…Using Smartsheet251Nolan Schmidt
-
Nest if/or formulaAnsweredAnswered raymond.j.riosiii94806 19 views 1 comment 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/22/20,Last post 01/22/20Hi Community, I need your help... I'm trying to create a formula that captures "No Action Taken". The individual IF Statements are as follows: If [Flu Vaccination Date] is "Blank" OR If [Flu Vaccination Date] is "…Formulas and Functions191raymond.j.riosiii94806
-
Error when submitting a form.AnsweredAnswered michael_hostetler85551 9 views 1 comment 0 points Most recent by Paul Newcome Using SmartsheetFirst post 01/22/20,Last post 01/22/20Workspace owner has created a form and published it. Users that are members of the workspace receive an error when attempting to submit the form. Error message is: There was an error submitting the form. Please try again. If the proble…Using Smartsheet91michael_hostetler85551
-
First post 06/19/19,Last post 01/22/20Now that you can do cross sheet formulas am I able to create s sheet for metrics data that can tally columns from another sheet using formulas?Using Smartsheet164Kimberly Greene
-
First post 09/18/19,Last post 01/22/20I’m working on a SUMIFS formula to add/sum numbers in 2 or more separate cells based on a checkbox input in 2 or more other cells. I’m able to do so only if the number columns and the checkbox columns are next to another. Is there a way …Formulas and Functions174Sam Gold
-
Tracking if a Project is on TimeAnsweredFirst post 01/22/20,Last post 01/22/20Is there a way to track if a project is running on time? Is a new cell column needed or how would you do this using End Dates etc? We want to display this in a dashboard (using klipfolio)Using Smartsheet161Clark Everson
-
First post 01/22/20,Last post 01/22/20Is there any functionality in place right now or planning for the future to allow a workspace/sheet creator to share ownership privileges with another individual? As a Project Manager, this ability would be extremely useful since many time…Using Smartsheet101Corina Terrazas -
Answered Jerome Szurubura 10 views 1 comment 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/22/20,Last post 01/22/20Hi, I would like to know if there is a way to launch the smartsheet refreshment. I explain: I made many sheets with many cells linked together with formulas like Vlook up. When I change the searching criteria (for example a name include in…Formulas and Functions101Jerome Szurubura
-
Answered prathap.krishnashetty69881 45 views 2 comments 0 points Most recent by Genevieve P. Formulas and FunctionsFirst post 01/19/20,Last post 01/22/20https://us.v-cdn.net/6031209/uploads/800/9LTGMPMXFSEF.jpg https://us.v-cdn.net/6031209/uploads/037/6UC2BVUD0ABT.jpg Hi, i'm trying to filter values without YES in Column2 of sheet Y by Vlookup from Column2, Column3 of sheet X where Column3…Formulas and Functions452prathap.krishnashetty69881
-
Calculating DurationAnsweredFirst post 01/20/20,Last post 01/22/20Hello, How can i set up a column to calculate how long it took to complete a task from the date it was assigned to date it got completed? I don't understand the dependencies in the project settings.Using Smartsheet211Juley Mathew
-
First post 01/21/20,Last post 01/22/20Hi, we are using Smartsheet's webhook API. We have the following use case. Consider user 'A' registered a webhook on a particular sheet. When some other Smartsheet user 'B' who has URL of the sheet of the user 'A' and tried to access the s…API & Developers221Anurag T
-
First post 11/01/19,Last post 01/22/20I'm new to this, and I'm having issues with counting the number of projects where Project Type = X and Project Status does Not equal Complete or Cancelled. I'm fumbling my way through unsuccessfully. This will go on a dashboard where I hav…Formulas and Functions337Brian Lynch
-
Answered Shawn Borror 27 views 2 comments 0 points Most recent by Genevieve P. Formulas and FunctionsFirst post 01/20/20,Last post 01/22/20I can't figure out how to do this formula and I've been searching for it in community. I've tried the following: =COUNTIFS(Portfolio Rollups Range 1, "Corp IT",AND({Portfolio Rollups Range 8},="In Progress",{Portfolio …Formulas and Functions272Shawn Borror
-
First post 01/22/20,Last post 01/22/20I've built a Smartsheet (with some help from the ProDesk) that assigns a task to a contact based on the date/time of a request. The sheet looks at the date stamp on the request then references another sheet (using WEEKNUMBER and WEEKDAY) …Formulas and Functions100Michael Palko
-
First post 01/20/20,Last post 01/22/20I have my cashflow forecast on Smartsheet, and i have a formula which looks at the balance on the row above to apply the balance for the current row as follows =BALANCE1350 + [in's]1351 - [out's]@row. When i shift the row up or down within…Formulas and Functions253AbbyT
-
First post 06/05/18,Last post 01/22/20I've read through all the instructions on https://help.smartsheet.com/articles/2476691-compare-live-data-with-a-chart#faq, and I'm still unable to create a chart like the one shown in the example. It says that the chart widget only support…Using Smartsheet1976mgriffin -
First post 08/16/18,Last post 01/22/20Hi, I’m part of an in-house legal department. The company has different departments and different types of contracts/advice they require us to produce. To track the work, I have created one sheet for the legal team to use, covering all…Using Smartsheet9612Tomer
-
First post 01/21/20,Last post 01/22/20I have an activity sheet set up by weeks. Meaning the same rows/sections are duplicated multiple times throughout the sheet. As the user fills in the names of their "Appointments" , what formula can I use to count that through…Using Smartsheet241TSP
-
Register and calendar integrationAccepted AnswerFirst post 01/05/20,Last post 01/22/20Hi, I need assistance in creating a calendar which will show the number of locations where material deliveries will happen (5 locations) over 24 hours - 365 days a year. The idea is to then create a dashboard with the form and calendar an…Formulas and Functions4720sahilhq
-
Change Time into MilitaryAccepted AnswerAccepted Answer Cheryl Petrich 45 views 19 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 01/15/20,Last post 01/22/20Hi all - Looking for solution to a simple task. Using a form that shows date in this format: 8:00 AM, 9:30 AM, etc., Want to add a second column (that will be hidden from form) that changes this to military time. No calculations involv…Using Smartsheet4519Cheryl Petrich
-
Answered Andrea Katz 34 views 5 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/07/20,Last post 01/22/20I'm wondering what the best way to do the following would be: I have about 100 districts and each one is assigned to one of four people. I want to populate a column with the names of the people associated with each district. Would this be …Formulas and Functions345Andrea Katz
-
First post 01/20/20,Last post 01/22/20Hi, I need to compare the hours allocated to the hours actually worked, through timesheets. For this I am using a spreadsheet to aggregate all the data from timesheets in order to extract metrics of hours worked by time and in which proj…Formulas and Functions291soeirorenan
