Using Smartsheet
Archives for February 2019
Discussion List
-
First post 02/28/19,Last post 03/22/19Good evening We have forms we created where one of our form entries is the name of the project. When we create a new project in smartsheet how can we make it so that the project is automatically included in the form dropdown so that w…Using Smartsheet136BESP10 -
First post 02/28/19,Last post 03/01/19Hi all what are the limitations of MS Project imports into smartsheets? the following is imported * task, start, end date * predecessors * completion % know of the following is not imported: * Base line * Parent predecessors what …Using Smartsheet51hanst -
First post 02/28/19,Last post 03/01/19Today was our first day on the Vista Job to receive PV materials and inventoryUsing Smartsheet22Alix Estrada
-
First post 02/28/19,Last post 03/01/19Hello, My office recently created an Internal Communications Intake Form on Smartsheet. The problem is, the column marked Today's Date seems stuck on Feb. 20, 2019. How can I fix it so that it will actually record the date when a project …Using Smartsheet22James Ponder
-
First post 02/28/19,Last post 02/28/19I was wondering if there is a way to have subtasks with fields that are different from the main tasks? We would like to use card view but have subtasks depending on the project that will have different criteria to meet than the main tasks…Using Smartsheet31CallmeQ -
First post 02/28/19,Last post 03/05/19Is it possible to block out certain dates with a date field in a form? For example, when the calendar comes up for March 2019, I don't want March 15 as an option. Is this possible?Using Smartsheet832julieoster
-
First post 02/28/19,Last post 02/28/19When submitting a form created in English can the content submitted include international characters? Are all languages supported?Using Smartsheet141julieoster
-
First post 02/28/19,Last post 02/28/19Is there a way to alert the user when, for example, they check a box, but other conditions are not currently being met? I see I can send emails and Slacks and whatnot, but I just want something to appear on screen. Thanks!Using Smartsheet162johnvilsack
-
First post 02/28/19,Last post 08/14/19I am trying to set an IF function to the At Risk column. I would like it to flag if the end date is within 2days or if the % complete task is less than 80%. Can someone help me set that function up? This is what I am putting in; =IF(A…Using Smartsheet24233brandi.meyer80376
-
First post 02/28/19,Last post 03/12/19I have one sheet that has metrics for a few of my employees, I was hoping there was a way to get the drop down menu function for each employee transferred onto a Dashboard highlighting everyone's metrics. *The drop downs show their total …Using Smartsheet1958NicoN
-
First post 02/28/19,Last post 05/08/19I want to create a formula in a checkbox column. I want the formula to go like this: I have 2 smartsheets. 1 is a sign-in sheet which will have a column for employee number. The 2nd smartsheet will be a smartsheet to search through th…Using Smartsheet15Michael Culley
-
First post 02/28/19,Last post 03/01/19Could Smartsheet add a brief how-to video on filtering to the help article? My team is asking for one and I can make it myself but I think the quality of Smartsheet's videos is excellent and would love to give them something more professio…Using Smartsheet21victoria.anzalone76406
-
First post 02/28/19,Last post 02/28/19Hi all, I am trying to set up a workspace to help manage multiple clients via projects. I have set up a template set for each project that includes plan, dashboard, key reports. My next step is trying to to roll up each project sheet i…Using Smartsheet431J_Legates
-
First post 02/28/19,Last post 02/28/19Hi, I have a grid that is shared with a lot of people. Some of them Admins and some Editors - Can share. From some reason, in the last few weeks all editors can't attach files to rows any more. Does anyone have a clue what could be …Using Smartsheet131Nofar_BK
-
First post 02/28/19,Last post 02/28/19Hi, we would like to share an inventory sheet to all of our company employees and I'm searching for a solution that will prevent the fact that I need to type every single email addresses into the share function. Does anyone has an idea on…Using Smartsheet143Audrey Larouche -
First post 02/28/19,Last post 03/01/19Hello I want to produce a record for equipment inspections. There will be over 100 items of equipment to list and inspection frequencies vary. I will need to show evidence that the inspection has been carried out, by whom and on what da…Using Smartsheet694AndrewR
-
First post 02/27/19,Last post 02/28/19Hi, Can I please have help with a formula. I want to show in a status column the following status': Current - if expiry date hasn't been reached Expiring Soon - If expiry date is in the next 60 days Expired - If expiry date is today…Using Smartsheet151RSanders
-
First post 02/27/19,Last post 02/28/19Is it possible to send an automatic Approval Request right after an automatic Update Request was filled in.Using Smartsheet332jcabza008
-
First post 02/27/19,Last post 03/02/19I have one column that shows what a risk is ranked as (a score from 1 to 49 with 49 being the most risky). I am trying to put in another column that lets a ranking for the effectiveness of the mitigation planning (score of 1-5) and then ha…Using Smartsheet133burkemrich -
First post 02/27/19,Last post 03/12/19I created a filter that: * Shows rows that match <all conditions> * <Status> <is not one of> <3 values selected> (DONE, DEAD, LATER) * <Archive> <is unchecked> The instructions my team is getting are t…Using Smartsheet1610johnvilsack
-
First post 02/27/19,Last post 02/28/19Hi, im trying to create a sign up sheet for an event through smartsheet form. is there a way to restrict how many times a value in a drop down can be selected? for example, if my sign up sheet ask user to sign up to a certain d…Using Smartsheet411Johnny Yang
-
First post 02/27/19,Last post 02/27/19Hi, I have a project queries management smartsheet and one of the Column Titles is "Done". I had chosen "Checkbox" as type of COLUMN PROPERTY. Now I have changed my mind and I want to change the COLUMN PROPERTY from …Using Smartsheet141FazalurRehman
-
First post 02/27/19,Last post 02/28/19Is it possible to view the task or sub-task assigned to a resource in a resource view? We use a multi-project sheet to encapsulate schedules and would like to track resources within a sheet as opposed to across sheets. As you can see in …Using Smartsheet321Sasha HC -
First post 02/27/19,Last post 02/27/19Are there any plans to add dynamic features to the forms? My main example is to have the ability to make a drop down list be changed/shortened/limited based on the selection of a previous drop down selection.Using Smartsheet21Darrick Ferrington
-
First post 02/27/19,Last post 02/27/19Is there a way to exclude cells that have a zero from charting? The bar chart does not show any data, but the topic headers, that have a zero, are cluttering the legend. If there is no data >0, I really would like the legend to not show…Using Smartsheet21Darrick Ferrington
-
First post 02/27/19,Last post 02/27/19Hello, I'm hoping there is a way to "clone" whole sheets, I don't want to re-reference the same sheets over and over again. -Making dashboards for my field teams.Using Smartsheet633NicoN
-
First post 02/27/19,Last post 02/27/19VERY new to SS. I am trying to write a formula that will insert red dot for any date that is prior to today, a yellow dot for any date that is that is between 1-30 days from now, and a green dot for any date that is 30+days from now and …Using Smartsheet43swoodring80171
-
First post 02/27/19,Last post 02/27/19Is it possible to re-open a form that is only partially completed but was submitted? We have fields in a form that need be completed at a different time and/or by a different person.Using Smartsheet27meunerie80161
-
First post 02/27/19,Last post 04/02/19Hi - new to Smartsheet and my MD and HR Director have asked me to look at rationalising some Google Sheets they use at the moment to track employees from initial interest through to starting with the company. I've looked at a couple of t…Using Smartsheet144TChalklen -
First post 02/27/19,Last post 02/28/19Bonjour, Est ce que l'un d'entre vous a déjà crée et partagé des rapports, via smartsheet? Si oui, Faut-il obligatoirement partager la feuille source des données afin de visualiser les informations dans le rapport ? De mon côté, je sou…Using Smartsheet24Peggy'