Using Smartsheet
Archives for October 2018
Discussion List
-
First post 10/31/18,Last post 11/01/18The formula is appearing on a particular sheet published report. This reappears after refreshing and saving the sheet. Please help :)Using Smartsheet12AdminAcacia -
First post 10/31/18,Last post 11/02/18I have a form that's only accessible to registered Smartsheet users. I believe that means that the System: Created By field will always be an email address. In that case, is it possible to use the System: Created By column as a Contact L…Using Smartsheet116JeffG
-
First post 10/31/18,Last post 11/01/18Hi there, Is there a way to auto-fill across the header? For example, if I put the very first date and then add a formula to add 7 days across until the end of the project? Or do you have to manually enter each header? I am trying to f…Using Smartsheet122JillrSchultz
-
First post 10/31/18,Last post 10/31/18I have bunch of demo units that are used by sales people. I want to use Forms to automatically populate a sheet with a customer name, the desired start date of a demo and the planned end date. Subsequently, I want to use Form to release t…Using Smartsheet132Tomi Lahcanski
-
First post 10/31/18,Last post 11/01/18I'm using the project template in smartsheet, in grid view. I've broken my project up in several phases, each phase a parent with child tasks. The Project % complete is coming out as 99% complete, but it is far from being that complete. …Using Smartsheet122Michele Deo -
First post 10/31/18,Last post 10/31/18It would be really nice if Unhide ALL wasn't the only option. I print info for several different people and some of the columns need to be seen by some but not all. I hide alot of columns so unhiding all just to change a couple is a total…Using Smartsheet322jenwillcockson -
First post 10/31/18,Last post 11/02/18I noticed there's a way to restrict columns for most column types except Text/Numbers. I want to only allow numbers to be typed in and not letters because when letters are typed into those cells, it messes up all my formulas. More specific…Using Smartsheet1106Michael Culley
-
First post 10/31/18,Last post 11/02/18Hi, I have several standard grid sheets that are populated via webforms, we are based within the UK. The issue I have is that I don't seem able to include "indent" function to the rows (i'd like to indent per month), as …Using Smartsheet556Stuart.d -
First post 10/31/18,Last post 11/14/18Hello! Today we have discovered that alerts in one particular (the others are working just fine) sheet are not working. I have tried few tips from the discussions but they don´t seem to be working at all. I have tried to check my spam f…Using Smartsheet4415Aneta Sevcikova -
First post 10/30/18,Last post 10/31/18A simple method to make a Gantt chart on SmartsheetUsing Smartsheet31ar11842167546
-
First post 10/30/18,Last post 10/09/19Dear Community: Please be gentle...I am new to the community. Our application uses forms to have people add row to various sheets. On one of the sheets we need to upload to one of 1000 systems as people continue to add to the sheets. I …Using Smartsheet2309tom55166 -
First post 10/30/18,Last post 11/02/18In Microsoft Project, you can set a project schedule's start and end date and that sets the date range for a project schedule. I can't see that feature in smartsheet. This would be nice since a lot of us use templates in our PMOs that we…Using Smartsheet582Michele Deo
-
First post 10/30/18,Last post 10/31/18Soy nuevo en SS. Agradezco saber si esta herramienta tiene la función de asignar costos a la actividad y su respectiva presentación. Hasta el momento, no he encontrado la función o columna.Using Smartsheet142Franger Andrés Vela
-
First post 10/30/18,Last post 10/31/18We have imported some project trackers and found a lot of Unparseable results. I am trying to find equivalencies to make my formulas work. Below is an example. =IF(C4=100%,TODAY()," ") In Smartsheet we tried this, =IF(Progr…Using Smartsheet113Janet Davis -
First post 10/30/18,Last post 10/31/18Hello I am using Smartsheet with Teams and discovered the filters don't work. From Smartsheets as the owner I don't have a checkbox to share the filter. Inside teams I can't create and name the filter and it only allows one filter at a …Using Smartsheet22dk
-
First post 10/30/18,Last post 11/03/18Hello SS Community! Am fairly new to SS, and was hoping someone might be able to point me to where I might find recommended solutions for resource demand, capacity, and utilization management, using Smartsheet. I know you can use the ti…Using Smartsheet422bonsai,
-
First post 10/30/18,Last post 10/30/18We use google docs currently for our company to input data about clients, and be assigned a specific project number. We have ~30 employees in the project book pulling these file numbers at any given time, so we like the transparency of see…Using Smartsheet281hwakefield
-
First post 10/30/18,Last post 10/31/18Hi everyone! I started using Smartsheet to control all the projects in my company(aproximatelly 9 projects). Some of them have confidential parts, but they also need colaboration of other employees. Can I create a unified task list for …Using Smartsheet212lkodato
-
First post 10/30/18,Last post 10/30/18Hello, Thanks to all for the wonderful help in the community! It makes everything so easy to use! I do have a question about something I was not able to figure out. I want to make a pie chart in a dashboard that reflects the status column…Using Smartsheet801randall.vanbemmel67451 -
First post 10/30/18,Last post 10/30/18I would like to calculate the # of calendar days given the following information: * Start Date * Work Days I know the "workday" formula will give me the end calendar date but I don't want the actual date. I am looking for the #…Using Smartsheet272Ramsay Zaki
-
First post 10/29/18,Last post 11/01/18Can you create a project portal with a MS project file (MPP), and update the portal as you update the project file?Using Smartsheet21fmiawama
-
First post 10/29/18,Last post 11/26/19Hello! When I right click on a row, the "Send Update Request" is grayed out and I am not able to click it. How do I fix this?Using Smartsheet394NBudd -
First post 10/29/18,Last post 10/30/18Is it possible to create a donut chart that includes a total amount in the middle? like the one attached bellow? (Image)Using Smartsheet421aura
-
First post 10/29/18,Last post 10/30/18Hi, It seems like when opening reports on the mobile in order to add one of the tasks fields, the form is opened with all sheet's columns instead of those who are only part of the report, do you know anything about it or if there;s a wor…Using Smartsheet31Lihi001 -
First post 10/29/18,Last post 11/05/19I have a massive sheet that have many collaborators updating their tasks and percentages. Is it possible for me to LOCK Rows and just allow specific users access to that specific Rows or Column. For exmaple: David Doyle can only edit R…Using Smartsheet5697alifarhan82
-
First post 10/29/18,Last post 10/30/18I have a Sheet which is populated by a form, and then calculates prices based on the entry responses. I want to create a metric on my dashboard that displays the pricing information for only the most recent entry, any tips? When I tried li…Using Smartsheet577Ryan- Impact
-
First post 10/29/18,Last post 11/26/18Hello, I have a Workspace that will soon have several dozen sheets or more. I have a Template for this Workspace and a Smartsheet on how to use the Workspace for my organization. It is going to get very easy for these two important sheets…Using Smartsheet324NBurrus -
First post 10/29/18,Last post 10/29/18I am looking to multiply a simple "quantity" times the "cost each" into a third cell. I created a formula but cells that have no entries in the quantity and cost cells yet, have totals as $0.00 in this column. I played …Using Smartsheet475Al W
-
First post 10/29/18,Last post 10/30/18Hello! I'm a new smartsheet user and I've been testing it for the past 2 weeks to decide whether to use it or not. My problem today is when I send an update request to a user and set an approval request to myself, the changes made by the…Using Smartsheet275Ahmed Lazrak
-
First post 10/29/18,Last post 10/29/18Hi. I have two columns : Deliverable status and Task status and I have the following conditions applied to the task status column: 1. If deliverable status = reported or shipped, then task status = complete 2. If deliverable status =…Using Smartsheet13C. Srinidhi Ragunathan
