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

  • Changing outlines of Gantt chart bars
    In Archived 2017 Posts
    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…
    41 1
    Closed 41 views 1 comment Most recent by JamesR Archived 2017 Posts
  • Smartsheet for business
    In Archived 2017 Posts
    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…
    Closed 1 view 3 comments Most recent by Andrée Starå Archived 2017 Posts
  • CountIF between 2 dates
    In Archived 2017 Posts
    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…
    903 6
    Closed 903 views 6 comments Most recent by aelmore Archived 2017 Posts
  • Forms and formulas
    In Archived 2017 Posts
    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…
    61 1
    Closed 61 views 1 comment Most recent by Shaine Greenwood Archived 2017 Posts
  • IF AND formula for RGY
    In Archived 2017 Posts
    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…
    267 4
    Closed 267 views 4 comments Most recent by Mike Wilday Archived 2017 Posts
  • Calendar View No Longer Working for Report
    In Archived 2017 Posts
    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…
    143 4
    Closed 143 views 4 comments Most recent by Susan B Peck Archived 2017 Posts
  • Date Format
    In Archived 2017 Posts
    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…
    82 3
    Closed 82 views 3 comments Most recent by Margaret Archived 2017 Posts
  • SUMIF with dates that land in a specific month
    In Archived 2017 Posts
    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.
    532 2
    Closed 532 views 2 comments Most recent by Stephanie Stoewe Archived 2017 Posts
  • How can I select data that is older than 365 day?
    In Archived 2017 Posts
    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"  
    1 2
    Closed 1 view 2 comments Most recent by Anil Archived 2017 Posts
  • How to auto-populate/insert 10-15 task rows as child items under new project row?
    In Archived 2017 Posts
    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.…
    468 14
    Closed 468 views 14 comments Most recent by Andrée Starå Archived 2017 Posts