Using Smartsheet
Archives for November 2018
Discussion List
-
First post 11/30/18,Last post 08/21/19I want to display a https link, but not make it clickable. There does not seem to be a way to remove a hyperlink. Has this issue ever been resolved? It might be a deal-breaker. TairaUsing Smartsheet3066taira70931 -
First post 11/30/18,Last post 12/31/18I just filled out a large CRM on a new sheet with several hundred clients. I was using the reminder feature to remind myself to send certain people an email or more information. Out of the 18 reminders I created, 11 of them tell me the ro…Using Smartsheet112suws
-
First post 11/30/18,Last post 01/28/19Is it possible to restrict the number format of form entries for text/number fields? I have some fields which are formatted for currency in the sheet, but the form will permit text to be entered in these fields. I see restriction for Da…Using Smartsheet1936tmayhall -
First post 11/30/18,Last post 12/07/18Hello! I am new to smartsheet and am having an issue. We have a schedule where we have several different project type options. Depending on the project type, the project types that are not applicable to that project are filtered out and hi…Using Smartsheet22Kronos
-
First post 11/30/18,Last post 12/03/18I find it really cumbersome for most to have to open each project and drill down to the specific parent or child, etc. to add a task. If someone opens a sheet and it has everything open it can be very intimidating. It would be nice if Smar…Using Smartsheet31Daryl McCann
-
First post 11/30/18,Last post 11/30/18I have an auto number column that I use to assign an employee number to new employees. From time to time we re-hire a termed employee, in which case we do not need a new number - we would just use the old. I have included a checkbox if t…Using Smartsheet152KSLOPER
-
First post 11/30/18,Last post 12/05/18Is there a way to visually/graphically see changes to an activity "before and after" on the Gantt or calendar view? I.E. if an activity is running longer than original input is there a way to show the original end point and the …Using Smartsheet115JDSS
-
First post 11/30/18,Last post 12/07/18I understand how to use the Resource View for resource allocation and view it across Groups/Projects/Users. I am interested to know if I can "turn off" the allocation % view of certain sheets. The reason I am interested in this i…Using Smartsheet382moskal
-
First post 11/30/18,Last post 11/30/18In my project, I'm trying to find the average of a few cells (in some cases it is only one cell), but I keep getting a #DIVIDE BY ZERO error message. Do you know why? (Image)Using Smartsheet3710ELaliberte
-
First post 11/30/18,Last post 12/03/18Looking for advice on the best way to prepare for the certification? Any study guides or tips? How is the test? Thanks!Using Smartsheet21Lori Shaw
-
First post 11/29/18,Last post 11/29/18Hi, I would like to be able to convert a completed Smartsheet form into a PDF document, either prior to submitting the form, or from the entry in the worksheet once the form has been submitted. Is there any functionality within Smartshee…Using Smartsheet3901sburgham
-
First post 11/29/18,Last post 01/15/19Is there a way to recover rows that have been deleted from a sheet?Using Smartsheet2623MEsparza
-
First post 11/29/18,Last post 12/03/18Is there a way to have the indent feature but to hide comments on a published sheet? I have a sheet that I want to share by publishing but I don't want comments to be visible because they contain sensitive data. I am using the indent feat…Using Smartsheet652Shane Alexander
-
First post 11/29/18,Last post 11/29/18Hi there, Checking to see if this is a feature before I submit a Product Enhancement Request. When our users get an @ mention in a comment or manipulate certain columns via reports Smartsheet kicks off some automated e-mails based on the …Using Smartsheet131Markus McKay-Fleisch
-
First post 11/29/18,Last post 12/21/18Want to Count "Total number of Tasks that are due in next 7 days" Currently using this but doesn't work: =COUNTIF([Production Move Date]14:[Production Move Date]149, >=TODAY(7)) Please Help!Using Smartsheet303Rafsun Royal -
First post 11/29/18,Last post 05/19/19I recently tested the Chart widget and like the functionality, but I can't ignore the fact the text is blurry. People I have shared the dashboard with also have remarked on how blurry the text is. Is this a problem others have experience…Using Smartsheet1516sanjayb
-
First post 11/29/18,Last post 12/07/18I have a report where I want to show results where: field A does not contain value 1 does not contain value 2 does not contain value 3 . . . does not contain value n Is there any upper limit to this or perfor…Using Smartsheet145Mike L.
-
First post 11/29/18,Last post 11/30/18I'm trying to troubleshoot a sheet I have. I have several entries that are not appearing on my sheet, and any new entries made are also not visible. I have a report generated off of the sheet and it reflects all of the entries. The approva…Using Smartsheet892SBrooks -
First post 11/29/18,Last post 11/29/18I have been successfully using the same smartsheet as a tracking system for almost a year. Recently I have realized that no one is receiving their notifications for one particular notification rule. It is not specific to one user not rec…Using Smartsheet31dolson
-
First post 11/29/18,Last post 11/29/18I am using this but showing "Invalid Operation: =COUNTIF([Current Overall Status]:[Current Overall Status], "QA") + =COUNTIF([Current Overall Status]:[Current Overall Status], "UAT") I am trying to count the tota…Using Smartsheet22Rafsun Royal
-
First post 11/29/18,Last post 11/29/18I want to be able to make a quick change to a filter without saving it. I want the filter I save to be the template, which I can make changes to, but the changes don't edit the template. I have plenty of useful filters and often want to …Using Smartsheet31suws
-
First post 11/29/18,Last post 11/30/18In our order tracker, we have a field that is a checkbox when a revision is needed. When it is checked it sends a notification to the appropriate team. What we are running into is once that revision is completed and checkbox unchecked, t…Using Smartsheet25scott_mcdade
-
First post 11/29/18,Last post 11/30/18I'd like to create a formula in a summary cell at the top of my sheet that counts rows in which the value in 1 column matches the value in another column at the same row. I'm hoping to do this without creating a helper column. Example: …Using Smartsheet141Jacob Slaathaug -
First post 11/29/18,Last post 11/29/18Hi , Can someone help me.. Will I select a option in Forms ( Tax applicable- Yes or No) If I click on Yes I should populate bring Country option to select and when I select No..its should not populate country option..Using Smartsheet11Jimmy
-
First post 11/29/18,Last post 11/30/18Hi all, My reports are not being updated. I have logged out and refreshed the report builder but still no updates or changes. Anyone else having similar issues?Using Smartsheet16George Gomes
-
First post 11/29/18,Last post 12/06/18All attachments for my Smartsheet program are from my Drop Box file on my computer. Staff with access have not had issue accessing them within our network. A staff member has indicated he was unable to open a file from the job site via his…Using Smartsheet11Al W
-
First post 11/29/18,Last post 07/06/19I'd like to create summary rows at the top of my sheet, but specifying the entire column as a range in the formula is causing #circular reference and #block errors. Is there a way to specify a range from row 25 to infinity? I'd like addi…Using Smartsheet1877Jacob Slaathaug
-
First post 11/29/18,Last post 11/29/18Is there a way of viewing historical reminders as they disappear from smartsheet once due date has past?Using Smartsheet23Mansho
-
First post 11/28/18,Last post 03/10/20I have a sheet published in Card View on our company Wiki page with Read Only - Full features. I'd like to have the ability to set the Published Card View to match how I have my sheet set up and not a generic Card View. For example, I h…Using Smartsheet274[email protected]