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
-
First post 12/30/17,Last post 01/02/18Hello, 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 Posts311Ulrich -
First post 12/29/17,Last post 08/12/18I 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 Posts13nycdesigned
-
First post 12/29/17,Last post 01/03/18Hello! 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 Posts3126aelmore
-
First post 12/29/17,Last post 01/02/18Hello, 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 Posts401elavoie
-
First post 12/29/17,Last post 01/05/18I 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 Posts864mmurphy14986 -
First post 12/29/17,Last post 02/05/18Hi 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 Posts574Susan B Peck -
First post 12/29/17,Last post 01/02/18Hi 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 Posts533Margaret
-
First post 12/28/17,Last post 02/07/19Im 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 Posts3212kitter82
-
First post 12/28/17,Last post 12/29/17How 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 Posts12Anil
-
First post 12/28/17,Last post 06/26/19What 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 Posts16214mcox23191
-
First post 12/28/17,Last post 05/06/19My 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 Posts393igor
-
First post 12/28/17,Last post 12/28/17Is 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 Posts141SPF23
-
First post 12/28/17,Last post 12/29/17I 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 Posts281Jason Hawker
-
Closed Alvaro Yurrita 44 views 1 comment 0 points Most recent by Shaine Greenwood Archived 2017 PostsFirst post 12/28/17,Last post 01/02/18When 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 Posts441Alvaro Yurrita
-
First post 12/27/17,Last post 12/28/17I 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 Posts1181Nross
-
First post 12/27/17,Last post 01/01/18Hi 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 Posts404Heath Sanders
-
First post 12/27/17,Last post 12/28/17Has 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 Posts1393MelissaR1180
-
First post 12/27/17,Last post 09/16/19I 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 Posts1413codyhaight
-
First post 12/27/17,Last post 11/28/18I 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 Posts1744mkleinhans
-
First post 12/27/17,Last post 01/16/19Hi, 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 Posts692DinaW
-
First post 12/27/17,Last post 12/29/17Hello – 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 Posts32afineline
-
First post 12/27/17,Last post 12/27/17Hello, 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 Posts161oakhayat
-
First post 12/26/17,Last post 12/27/17I 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 Posts341patredd
-
First post 12/26/17,Last post 10/29/19I 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 Posts2524Anil
-
First post 12/26/17,Last post 12/26/17Is 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 Posts1032simonk
-
Closed Stewart Grinton 51 views 1 comment 0 points Most recent by Shaine Greenwood Archived 2017 PostsFirst post 12/26/17,Last post 12/28/17I 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 Posts511Stewart Grinton -
First post 12/23/17,Last post 12/27/17Hello, 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 Posts333oakhayat
-
First post 12/22/17,Last post 12/25/17If 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 Posts12deMajix
-
First post 12/22/17,Last post 12/23/17I 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 Posts181Jill_R
-
Closed Richard Lessard 6 views 1 comment 0 points Most recent by Shaine Greenwood Archived 2017 PostsFirst post 12/22/17,Last post 12/26/17We 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 Posts61Richard Lessard