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.
Solution Center
Discussion List
-
Accepted Answer Justin Runner 38 views 7 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/21/20,Last post 01/23/20I'm looking for a formula to help me calculate the length of hours an individual has worked. Employees enter their "Haul Start Time" and "Haul End Time" manually by picking from a drop down list of times in 24hr format.…Formulas and Functions387Justin Runner -
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 08/10/18,Last post 01/22/20Is there a way to have a row come in automatically at the same indent level as the row above it? My top row is a parent row with calculations based on all of its children. The children rows are all web form generated and they do not come i…Using Smartsheet476RossL
-
First post 08/15/18,Last post 01/20/20I am running a report from my sheet however the primary column shows up even though I did not select it and I cannot hide it. I don't want/need it in my report. I was wondering if there was a way to remove or prevent it. Thanks!Using Smartsheet635Sgiovinazzo
-
SummaryAccepted AnswerAccepted Answer Kristie Diersen 9 views 1 comment 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/17/20,Last post 01/17/20I am trying to find a way to do a monthly summary of the number items each month in Published, and Expired Alert Status. https://us.v-cdn.net/6031209/uploads/277/JKXO5DMT4B8I.jpg Does anyone know what would be the best way to complete th…Formulas and Functions91Kristie Diersen
-
tcanelli41471 46 views 3 comments 0 points Most recent by Andrée Starå Premium Apps and IntegrationsFirst post 03/15/18,Last post 01/09/20Is there anyone that would be willing to work with me on the phone to work through this issue: I've created a sheet that has over 40 columns - it's my "master" sheet that feeds a bunch of reports that will be utilized by differe…Premium Apps and Integrations463tcanelli41471
-
First post 09/10/19,Last post 01/07/20We all love a Freebie? OUR API development team get lots of requests for automation which is the basis of our Smarter Mini Control Center 12 Apps, but one request we have been unable to fulfill so far (unless we use Appsheet with Smartsh…API & Developers2132Richard Rymill SBP -
First post 01/06/20,Last post 01/06/20I have made several workflows that were fairly large for different applications in smartsheet. I would like to have a simple function to print/pdf the workflows so as to see all of one at once. This would help me with design, troubleshooti…Formulas and Functions150[email protected]
-
First post 09/16/19,Last post 12/18/19After seeing very nice dashboard presented in Best in Class Project Management video I tried to start developing something similar for our organization. However I'm struggling with creating customized buttons (like "Home", "…Using Smartsheet687Maxim Lobko
-
First post 12/18/19,Last post 12/18/19The aim is micromanage / manually edit lists as little as possible. I would like to use automation for situations below: Is there a way to automatically stop/block the option for duplicate enrollments from the same person ( based on email …Formulas and Functions152Eva Koczan
-
First post 12/17/19,Last post 12/17/19Hi, I'm looking for some help on how to eliminate some risk when team members leave the company. They are deleted as a user and sheets transferred, however these said users after they have been deleted are still able to access into Smartsh…Using Smartsheet221Jorjie Higginson
-
First post 11/21/19,Last post 12/08/19Good Afternoon, I am very new to smartsheet and still trying to find my way around. I am wondering if it is possible with smartsheet that if you have a drop down menu if 1 particular option is chosen could you have other drop downs pop u…Using Smartsheet222[email protected]
-
First post 09/19/18,Last post 12/08/19I've reached out to our account manager and also sent a request via the web form, but have not heard back from anyone. What I've been looking for is the "Template Set" for the Product Testing solution (Test Plan, Test Log, Bug Tr…Using Smartsheet394Peterhvh
-
First post 12/06/19,Last post 12/06/19Dears, Our customer has a number of unlicensed users which work on Smartsheet. A new employee joined and created a new free trial user account. This user is not able to email comments out of a sheet: "You've exceeded the maxim…Using Smartsheet184Mitch Van Riel
-
First post 12/05/19,Last post 12/06/19I understand this is not a place to deal with indivisual cases, but as I cannot reach anyone in Smartsheet, I've decided to write here. Thought I've been trying to contact Smartsheet since mid-November either through "Contuct us"…Using Smartsheet273E Sa
-
First post 11/16/19,Last post 12/05/19I work in the IT Department at a company. Another department assigns tasks to our department for software support for a particular application that they use. We would like for them to rank the tasks that they want us to complete - with num…Using Smartsheet246hollywallace -
First post 12/04/19,Last post 12/05/19Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…Formulas and Functions352KDub618
-
First post 12/04/19,Last post 12/05/19Hi All! I am at a loss at how to even start this design. I have approximately 15 tasks that occur every month on the same BUSINESS day I have another 5 tasks that occur on the same business day every quarter. I would like to…Using Smartsheet272Jeager
-
First post 03/18/16,Last post 12/04/19It would be great if Smartsheet could provide a count of rows in an already generated reports, and if that count could be cell inked to. This is not the same as criteria based counting in a sheet, which is great unless you are trying…Archived 2016 Posts9024Billy Heidt
-
First post 09/17/18,Last post 12/02/19We currently use a portfolio sheet that tracks our pipeline of clients and organizes them by stages. We love this sheet as it provides us with very useful management level information. However, it does not allows us to manage the "wo…Premium Apps and Integrations3216Jef Forward -
First post 12/02/19,Last post 12/02/19I need to be able to unhide one single column. NOT ALL. Is there a feature where I can pick the column I need to view. We have weekly columns that go back 2 plus years. I do not need to see over 100 columns unhidden. The unhide all feature…Using Smartsheet231haleyp123
-
First post 08/07/17,Last post 12/01/19My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down? Below is the formula in E…Archived 2017 Posts202Michael.Baker
-
First post 11/27/19,Last post 11/28/19Are there any templates available for architectural design project? I know there are several construction templates but I am more interested in architecture / design specific and the workflows related to the specific processes.Using Smartsheet302NP
-
First post 11/26/19,Last post 11/26/19I have just been assigned the task of setting up the Project Management Office in my company. For now I need two things, firstly a project tracker for tracking and monitoring individual projects and then a master portfolio tracker where al…Formulas and Functions311bukkymoh01
-
First post 11/25/19,Last post 11/26/19Good Day All, I am trying to familiarize myself with Dynamic View. My questions is, upon sharing the view with someone (lets say I share with my accountant) how do we send requests to update things WITHIN dynamic view? Let me propose a…Premium Apps and Integrations321PMA98681
-
First post 08/23/19,Last post 11/25/19Hello, If I'm building a website, can I create a custom HTML form and get the data into Smartsheet somehow? Smartsheet's native forms don't have the capabilities that I need (conditional logic) and I would like to make my forms a bit pret…API & Developers607pnc51
-
First post 03/26/18,Last post 11/22/19I've seen posts going back 3 years that address this subject, and it's little mind blowing that a feature as basic and essential as this does not seem to be possible yet. My team works on multiple projects each day, and each project has at…Using Smartsheet576Jesse L
-
First post 11/17/19,Last post 11/22/19I have a Master SmartSheet from which I pull new rows into a SmartSheet Report. That works fine for Report users who are safe to have access to all the information in the Master SmartSheet. However, I have other users who need some row dat…Using Smartsheet111thomasbeaty111566
-
First post 11/20/19,Last post 11/20/19I was hoping I could get some help here. So I've decided to create a status for each of the tasks my employee is working on. Categories include: Done On Deck In Progress Not Started There is a checkbox column for each category…Formulas and Functions182Kristina Howes
-
First post 11/20/19,Last post 11/20/19Hi, I'd like to do the following IF([Done]@row=1,"Complete),IF([Target Date]@row<14, "On Deck",<leave unchanged>) Is the whole concept of leave unchanged an option? Because I'd like to keep the default tha…Using Smartsheet192Kristina Howes
