Using Smartsheet
Archives for November 2019
Discussion List
-
First post 11/30/19,Last post 12/02/19Hello My organization has finalized our 2020 Capital Ex Budget. Starting in January 2020, I want to create a Capital Exp Form that provides the options that were approved for the 2020 Cap Ex Budget. For example, the form would be set up …Using Smartsheet361Nillie D -
First post 11/30/19,Last post 12/02/19In my 'Install' sheet status column I have a formula =IF(Health3 = "red", "At Risk", IF(Health3 = "yellow", "On Hold", IF(Health3 = "blue", "In Progress", IF(Health3 = "gree…Using Smartsheet381FusiaSuede
-
First post 11/29/19,Last post 12/01/19I'd like to publish my sheet and have it default to the gantt view so that users see the gantt view by default. Right now, the default view only shows the grid. Is it possible to change the default view when publishing a link?Using Smartsheet411bill.cronin
-
First post 11/29/19,Last post 11/29/19A number of regions (countries) have very tight internet use. It would be helpful to be able to download local version, work on it while abroad and resync on return.Using Smartsheet881creinink
-
First post 11/29/19,Last post 01/30/20Hello, I am starting to test out the new Proofing functionality and was wondering if there are permission level limitations on who can send out the "Set up Review Request"? We have some people who are admins and some who are not…Using Smartsheet634Astazio -
First post 11/29/19,Last post 12/16/19Hi Can you all please view the attached file. The problem is self-explanatory: whether the duration is normal (the 1st row), or it is written with the letter "e" (for elapsed time), the Finish date remains the same! I have …Using Smartsheet372[email protected]
-
First post 11/29/19,Last post 11/29/19Hello, in Smartsheet's "Project Management Fundamentals" course, specifically in the section on Reporting, there's a great example on how you can compare the original plan (baseline) to actual project dates. The solution illustra…Using Smartsheet293Ivana
-
First post 11/29/19,Last post 11/29/19Hi One of the users in my team has Unsubscribed the automation message by mistake. How do I turn this on again for her? Also, how do I know how many of my users have unsubscribed themselves in the same manner? ThanksUsing Smartsheet453[email protected]
-
Proofing- Previous VersionsAccepted AnswerAccepted Answer Conner Sherman 70 views 12 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 11/28/19,Last post 02/04/20Hello everyone, I have been using the proofing feature in our team for internal proofing. I have an issue where as soon as you add a new document version, the previous versions are no longer visible they sit loading. You can still down…Using Smartsheet7012Conner Sherman
-
First post 11/28/19,Last post 11/28/19Anyone experiencing problems accessing their sheets; we just went down.Using Smartsheet211Adam D
-
First post 11/27/19,Last post 12/02/19I am trying to find a way on the Smartsheet web form to display the Name from the contact list, but not the email address. This is a public form, and while I want to be able to alert the event coordinator that something has been submitted,…Using Smartsheet253[email protected]
-
First post 11/27/19,Last post 11/29/19I think this should be easy but I keep getting "divide by zero" error. I just need to find the total percent complete using percents from 6 different columns (same row) on a sheet. Ex: C1 C2 C3 C4 C5 C6 …Using Smartsheet245noclue -
First post 11/27/19,Last post 12/02/19Hi! I'm trying to set up a workflow which sends notifications only to a contact in a cell which is part of a contact column. Although permissions are set to "Unrestricted" the workflow isn't working! A test environment with m…Using Smartsheet893Andreas Krause
-
First post 11/27/19,Last post 12/01/19I have a drop down column with the dates formatted as "Saturday, November 23, 2019" so people can select class dates. I need to convert those to an actual date column so I can sort by date in a report but I cannot figure out the…Using Smartsheet132Shayma Gross
-
First post 11/27/19,Last post 11/27/19This is just to share a rather difficult solution I was required to develop this morning, converting the California server time to Central Time in a created column (Named "Created"). If anyone has a better solution I would love t…Using Smartsheet316[email protected]
-
First post 11/27/19,Last post 11/27/19I am using this formula in a cell: =100*(COUNTIFS([FW % Complete]13:[FW % Complete]24, 1) / COUNT([FW % Complete]13:[FW % Complete]24)) + "%" I would like to know how to make the percentage round to the nearest percentage. R…Using Smartsheet185noclue
-
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 Smartsheet872NP
-
First post 11/27/19,Last post 11/29/19I am trying to work through multiple if/and statements to use red/yellow/green/gray indicators without much luck. Essentially, I would like the formula to produce the following: If % Complete = 1, Green If % Complete < 1, and finish …Using Smartsheet265Katie Cobb
-
First post 11/27/19,Last post 11/27/19Is it possible to set up an automated, weekly request for individuals to complete a Smartsheet form? Individuals would be adding new rows each week, not updating existing rows. Therefore, I can't tie the workflow to a specific condition. T…Using Smartsheet391Melanie Kourbage
-
First post 11/27/19,Last post 11/27/19Is this possible, only seem to be able to add one at a time, is there a way to add multiple?Using Smartsheet241Lisa.stubbs112706
-
First post 11/27/19,Last post 11/27/19I have a first sheet name 'customer contact' On other sheet name 'report' where I use the customer contact list to make a dropdown list. My question : It is possible to refresh automatically the drowpdown list when I add a new contact in…Using Smartsheet312WISZ
-
First post 11/27/19,Last post 11/27/19I have my sheets set up where each row represents a project and respective information. I have a column in each that can be changed to a department heading and I have an automation set up to make it so that when changed the rows move to t…Using Smartsheet833Aaron D.
-
First post 11/26/19,Last post 11/27/19Hi, Why as an Admin, I can't edit dashboard and to add more widgets or edit sheets? I don't like to be in a box because Cloud Platforms such as Smart Sheet should increase our efficiencies! Thank you, MattUsing Smartsheet122Matt18
-
First post 11/26/19,Last post 11/28/19Hi I am trying to set up a cell that automatically set a word in a cell depending on what the due date is. If date is less than today's date "overdue" will be added to cell, If date is more that today's date "on track wil…Using Smartsheet143VioletB
-
First post 11/26/19,Last post 11/27/19I am trying to count the number of times a specific schedule date is listed in a column for a sheet, not able to narrow down the formula exactlyUsing Smartsheet132adrian.bleivns112656
-
First post 11/26/19,Last post 12/03/19Hi, We're about to implement a new EMR system at our clinic system. Was wondering if anyone else has done this with Smartsheet. Would like to hear about lessons learned, how you used Smartsheet etc. Thanks! LindaUsing Smartsheet384lwatts
-
First post 11/26/19,Last post 12/02/19Hi, i am trying to create a workflow for more than one column. I want to use the same exact condition for multiple column at the time. I have over 20 column so it would be long to create 20 workflow that basically do the same thing. Is t…Using Smartsheet323Tgoud27
-
First post 11/26/19,Last post 12/03/19I have been trying to create an automated workflow that triggers an email to the assigned to person when the Due Date field is not completed. I have tried different intervals, but it still isn't working. I have checked the permission set…Using Smartsheet373DSheridan
-
First post 11/26/19,Last post 11/26/19Is there a way to retain email messages as comments, when they are sent directly from a row in Smartsheet? If not, this would be a great addition.Using Smartsheet241Ian Soares -
First post 11/26/19,Last post 11/27/19Hi! Can I use a Sheet Summary Report to drive a Metric widget? I have 25 project sheets that I would like to roll-up into a sheet summary report. I would then like to create dashboard metric widgets using this data. I am currently drivin…Using Smartsheet869SheaD
