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 barsIn Archived 2017 PostsHello, 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…
-
Smartsheet for businessIn Archived 2017 PostsI 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…
-
CountIF between 2 datesIn Archived 2017 PostsHello! 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…
-
Forms and formulasIn Archived 2017 PostsHello, 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…
-
IF AND formula for RGYIn Archived 2017 PostsI 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…
-
Calendar View No Longer Working for ReportIn Archived 2017 PostsHi 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…
-
Date FormatIn Archived 2017 PostsHi 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…
-
SUMIF with dates that land in a specific monthIn Archived 2017 PostsIm 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.
-
How can I select data that is older than 365 day?In Archived 2017 PostsHow 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"
-
How to auto-populate/insert 10-15 task rows as child items under new project row?In Archived 2017 PostsWhat 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.…