Archived 2017 Posts

Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Archived 2017 Posts

Archives for December 2017

Discussion List

  • Ulrich
    Closed Ulrich 46 views 1 comment Most recent by JamesR Archived 2017 Posts
    First post 12/30/17,Last post 01/02/18
    Hello, I would like to change the colors of the outlines/lines around the bars for sub-activities in the Gantt chart. I was able to change the fill color but the outlines are still light blue. Is there a way to change the color of the ou…
    Archived 2017 Posts461
    Ulrich
  • nycdesigned
    Closed nycdesigned 1 view 3 comments Most recent by Andrée Starå Archived 2017 Posts
    First post 12/29/17,Last post 08/12/18
    I used smartsheet earlier this year and liked it for several things, like excel on steroids. But then as my business grew I needed more systems to manage sales, customers, inventory, etc. etc. I found myself signing up for more and more so…
    Archived 2017 Posts13
    nycdesigned
  • aelmore
    Closed aelmore 650 views 6 comments Most recent by aelmore Archived 2017 Posts
    First post 12/29/17,Last post 01/03/18
    Hello!  I'm trying to count the number of children whose "Final Approval Date" is between 6/1/17 and 10/1/17. I don't even know where to start with this formula. I know I've got my weekly totals like this: =COUNTIF([FINAL APPRO…
    Archived 2017 Posts6506
    aelmore
  • elavoie
    Closed elavoie 64 views 1 comment Most recent by Shaine Greenwood Archived 2017 Posts
    First post 12/29/17,Last post 01/02/18
    Hello, I am new to Smartsheets and am creating a form to send out and collect orders from customers. Now the form works but I need it to populate the new rows that get added with pricing from another sheet. Is this possible as I am not fi…
    Archived 2017 Posts641
    elavoie
  • mmurphy14986
    Closed mmurphy14986 195 views 4 comments Most recent by Mike Wilday Archived 2017 Posts
    First post 12/29/17,Last post 01/05/18
    I am working on a project plan that needs to show the "health" of each task based on the finish date and the status.  I've been able to do a formula that checks the status and then selects the correct RGY and I've been able to do…
    Archived 2017 Posts1954
    mmurphy14986
  • Susan B Peck
    Closed Susan B Peck 109 views 4 comments Most recent by Susan B Peck Archived 2017 Posts
    First post 12/29/17,Last post 02/05/18
    Hi all, I have a report that pulls specific tasks with dates from two different sheets, which I use as a high-level to do list. My preference is to show the results in the Calendar view because it helps with planning.  In the past, the r…
    Archived 2017 Posts1094
    Susan B Peck
  • Margaret
    Closed Margaret 80 views 3 comments Most recent by Margaret Archived 2017 Posts
    First post 12/29/17,Last post 01/02/18
    Hi I need the date to be in the format of yyyymmdd so that I can concatenate with other cells to form document name. Otherwise, it would be manual process for me to go through every single documents to name them. Currently my settings is…
    Archived 2017 Posts803
    Margaret
  • kitter82
    Closed kitter82 479 views 2 comments Most recent by Stephanie Stoewe Archived 2017 Posts
    First post 12/28/17,Last post 02/07/19
    Im trying to use the sumif function to match 2 columns of data, transaction type, and corresponding value then return only month specific dates read from a date column.  Date column is in mm/dd/yy format.
    Archived 2017 Posts4792
    kitter82
  • Anil
    Closed Anil 1 view 2 comments Most recent by Anil Archived 2017 Posts
    First post 12/28/17,Last post 12/29/17
    How can I select data that is older than 365 day? =COUNTIFS(Product:Product, "ABC", [Project Complete Date]:[Project Complete Date], "Where Project Complete Date is < 365 days from today"  
    Archived 2017 Posts12
    Anil
  • mcox23191
    First post 12/28/17,Last post 06/26/19
    What is the best way to automatically insert a set of (about 10) rows as child tasks under each project row?  I am designing a smartsheet based on the Project Sheet template, but in my case we manage a large number (about 150) of projects.…
    Archived 2017 Posts35014
    mcox23191
  • igor
    Closed igor 58 views 3 comments Most recent by Schiff A. Archived 2017 Posts
    First post 12/28/17,Last post 05/06/19
    My Company from Slovenia is using SmartSheet to track inquires/sales all over the world. Each inquiry gets its own line and we enter in this line also country from where demand came from. Curenty we use this sheet only internal-  only in c…
    Archived 2017 Posts583
    igor
  • SPF23
    Closed SPF23 27 views 1 comment Most recent by Mike Wilday Archived 2017 Posts
    First post 12/28/17,Last post 12/28/17
    Is there a way to make templates for Forms and then add them to each of our projects?  I see where you can build forms and then clone them inside of a sheet but we would be looking to copy those forms into other sheets.  Is there an easy w…
    Archived 2017 Posts271
    SPF23
  • Jason Hawker
    First post 12/28/17,Last post 12/29/17
    I have read posts where it says to use project plan FILTERS or create one off REPORTS to execute this requirement. This seems inefficient and each option lacks what the other provides.  NEED: I want an all in one feature within a project…
    Archived 2017 Posts401
    Jason Hawker
  • Alvaro Yurrita
    Closed Alvaro Yurrita 107 views 1 comment Most recent by Shaine Greenwood Archived 2017 Posts
    First post 12/28/17,Last post 01/02/18
    When a user makes changes to a cell in a smartsheet from inside a tab in Microsoft teams (either in the Teams app or in the Teams Web Client), when looking at the Cell History the cell changes are logged as belonging to "Publish User&…
    Archived 2017 Posts1071
    Alvaro Yurrita
  • Nross
    Closed Nross 237 views 1 comment Most recent by Robert S. Archived 2017 Posts
    First post 12/27/17,Last post 12/28/17
    I need to populate the low range based on a  match to a specific specialty and tier.  The specialty is just a drop down but the Tier was based on the following IF formula: =IF([Points Total]11 <= 15, 3, IF([Points Total]11 >= 16, 2,…
    Archived 2017 Posts2371
    Nross
  • Heath Sanders
    Closed Heath Sanders 76 views 4 comments Most recent by Heath Sanders Archived 2017 Posts
    First post 12/27/17,Last post 01/01/18
    Hi Team, I have a formula that calculates tax automatically as I enter the amount. I wanted to add Checkbox column, when I tick the box it removes tax and if its untick it continues with original formula.      =IF(Status1 = "WON&quo…
    Archived 2017 Posts764
    Heath Sanders
  • MelissaR1180
    Closed MelissaR1180 227 views 3 comments Most recent by Robert S. Archived 2017 Posts
    First post 12/27/17,Last post 12/28/17
    Has anyone used SS to track actual time spent? I am using the "Time Track for Client Projects" template modified for simple tracking of time spent for individual tasks by client or department. I cant seem to get the formula neede…
    Archived 2017 Posts2273
    MelissaR1180
  • codyhaight
    Closed codyhaight 247 views 3 comments Most recent by Rizzi-CTX Archived 2017 Posts
    First post 12/27/17,Last post 09/16/19
    I have a card view that is set to display with a filter on by default.  Is it possible to also Publish this to the Web with a filter on by default?
    Archived 2017 Posts2473
    codyhaight
  • mkleinhans
    Closed mkleinhans 357 views 4 comments Most recent by Jose Alvarez Archived 2017 Posts
    First post 12/27/17,Last post 11/28/18
    I am new to Smartsheet and I'm trying to create a report from multiple sheets that have parent rows and child tasks.  I'm looking for a report that puts together all the sheets but only shows the parent rows from each sheet along with the …
    Archived 2017 Posts3574
    mkleinhans
  • DinaW
    Closed DinaW 122 views 2 comments Most recent by Joachim Mund Archived 2017 Posts
    First post 12/27/17,Last post 01/16/19
    Hi, Is there a way to set up hierarchy with several tasks and different dates, and not have the parent row's date, which ranges from the first to the last date in the tasks below it, show in calendar view? I want just the children rows to…
    Archived 2017 Posts1222
    DinaW
  • afineline
    Closed afineline 4 views 2 comments Most recent by afineline Archived 2017 Posts
    First post 12/27/17,Last post 12/29/17
    Hello – I am trying to create a formula that will change RYG automatically with the following criteria: Green:  Any positive (%) Yellow:  0 to negative 10% Red:  less than negative 10% With the below formula, green and yellow work fine…
    Archived 2017 Posts42
    afineline
  • oakhayat
    Closed oakhayat 25 views 1 comment Most recent by Robert S. Archived 2017 Posts
    First post 12/27/17,Last post 12/27/17
    Hello, I have created 3 columns for the RYG, if the project is in the early stages the color green will show, if it is due within 4 days, yellow will show, and when it is due in 2 days red will show. Now I have a checkbox for the employe…
    Archived 2017 Posts251
    oakhayat
  • patredd
    Closed patredd 63 views 1 comment Most recent by Robert S. Archived 2017 Posts
    First post 12/26/17,Last post 12/27/17
    I have reminder set on various rows in the sheets in my Smartsheet. Is there a way to have the "date" that is set on each reminders displayed in a column on the same row? In the attached screenshot...  Row 1...  the reminder in…
    Archived 2017 Posts631
    patredd
  • Anil
    Closed Anil 587 views 4 comments Most recent by Andrée Starå Archived 2017 Posts
    First post 12/26/17,Last post 10/29/19
    I am trying to calculate the average duration taken to complete a project for a date range. I get a “ #Divide By Zero “ error and would like to use IERROR function to get 0 when divided by 0 instead of the error message. Please see the for…
    Archived 2017 Posts5874
    Anil
  • simonk
    Closed simonk 187 views 2 comments Most recent by Mike Wilday Archived 2017 Posts
    First post 12/26/17,Last post 12/26/17
    Is there a way to restrict certain users from editing curtain fields? For example, we are using Smartsheet so users can enter info waiting for approval, but we want only admin should be able to mark off "check box" for approvals.
    Archived 2017 Posts1872
    simonk
  • Stewart Grinton
    Closed Stewart Grinton 117 views 1 comment Most recent by Shaine Greenwood Archived 2017 Posts
    First post 12/26/17,Last post 12/28/17
    I use Smartsheet to track video production in my department and there is a request to associate video links (vimeo urls) to each project row. I've tried creating a whole new column containing a hyperlink, but that clutters up the master s…
    Archived 2017 Posts1171
    Stewart Grinton
  • oakhayat
    Closed oakhayat 63 views 3 comments Most recent by Robert S. Archived 2017 Posts
    First post 12/23/17,Last post 12/27/17
    Hello, I was wondering is it possible to make the status RYG color changes when it is closer to the due date? For example: it shows red when it is due two days before the date and so on... Is there a formula to right and what is the for…
    Archived 2017 Posts633
    oakhayat
  • deMajix
    Closed deMajix 1 view 2 comments Most recent by deMajix Archived 2017 Posts
    First post 12/22/17,Last post 12/25/17
    If column 3 is greater than 10, then i need the formula in column 1 be use and if column 3 is lesser than 10 formula in column 2 should be use. I am putting this formula in column 4. Please i just badly needed it! Thanks...
    Archived 2017 Posts12
    deMajix
  • Jill_R
    Closed Jill_R 24 views 1 comment Most recent by Andrée Starå Archived 2017 Posts
    First post 12/22/17,Last post 12/23/17
    I have a sheet that contains a list of expense transactions.  In that sheet, I have a checkbox column and if the expense is tax deductible, I check that box for that line item. I would like a new sheet to pull over and list just the trans…
    Archived 2017 Posts241
    Jill_R
  • Richard Lessard
    First post 12/22/17,Last post 12/26/17
    We are using smartsheet to share information between functional groups and DataMesh is the primary tool used to copy/paste the information between sheets.   Recently (within the last two weeks), I have come across several datamesh configs…
    Archived 2017 Posts31
    Richard Lessard