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 2016 Posts
Archives for November 2016
Discussion List
-
First post 11/30/16,Last post 12/02/16I have had this issue on and off for a few weeks. After using toolbar to make changes to sheet the columns dont line up with the header descriptions. Anyone else having the same issue? Regards Wayne (Image)Archived 2016 Posts13Wayne Burr -
Closed Kelly Hogan 20 views 5 comments 0 points Most recent by J. Craig Williams Archived 2016 PostsFirst post 11/30/16,Last post 12/02/16I'm having a hard time and maybe it's because it's obviously not even possible? I'm wondering if a checked box can also equal a numeric value without adding additional columns. Possible? (Photo referenced below) If so, GOAL: Ex i…Archived 2016 Posts205Kelly Hogan
-
Closed Gary Jones 111 views 4 comments 0 points Most recent by Richard Rymill SBP Archived 2016 PostsFirst post 11/30/16,Last post 01/08/19Can anyone tell me if you can insert page breaks in a schedule so that when you print it will print as seperate pages?Archived 2016 Posts1114Gary Jones
-
First post 11/30/16,Last post 11/30/16Hi all - this seems like it would be easy but I cant figure it out. I have a spreadsheet with different sections, most rows I DO want the check boxes but on my header rows which are separateing my sectinos I DO NOT want the check boxes but…Archived 2016 Posts1733lrs
-
First post 11/30/16,Last post 02/19/19Hi Community - Looking to crowdsource the best method of creating a Master Sheet (think: Company ALL) composed of smaller Department Sheets (think: Marketing, Development, etc). The ideal set up here is that while only I may have a…Archived 2016 Posts2778Emeka
-
Closed Spencer MacGillivray 67 views 5 comments 0 points Most recent by Spencer MacGillivray Archived 2016 PostsFirst post 11/30/16,Last post 12/01/16So I have what I hope is a common issue resulting in a simple solution - when I make a change on my mobile app, the desktop "main" sheet doesn't automatically update. The only way I can think of to work with this is to remember t…Archived 2016 Posts675Spencer MacGillivray
-
Closed Blair blair9398 26 views 7 comments 0 points Most recent by Blair blair9398 Archived 2016 PostsFirst post 11/30/16,Last post 12/03/16For large sheets, is there a way to link from rows to other rows within the same sheet. For example, I have developed a lirbary of sorts with files that fall into different categories. There are several categories and lots of files in ea…Archived 2016 Posts267Blair blair9398
-
First post 11/30/16,Last post 12/02/16I have someone set as an admin for a workspace, but they cannot add new columns to sheets in there. Can only the owner add columns?Archived 2016 Posts174tobrien3
-
First post 11/30/16,Last post 12/01/16Hi everyone. I particularly like the Kanabvan sheet as we can visually see the progress of a project as it moves from one are to the next. However, im looking to see if its possible to create "sub lanes" within lanes to creat a f…Archived 2016 Posts172104
-
First post 11/30/16,Last post 12/02/16Fairly new user here. Looking for help in rolling up our divisional budgets into a consolidated budget. I have an income statement budget template for each division which has worked beautifully with callaboraters completing their info…Archived 2016 Posts372Joni Manley
-
Closed Curtis Anderson 1 view 3 comments 0 points Most recent by J. Craig Williams Archived 2016 PostsFirst post 11/30/16,Last post 11/30/16Hello - I would like to keep the start and end date of a project. Without having an attachemnt associated with the project, can I add people and their roles for this project, on the lines below the project, and then hide those lines? Th…Archived 2016 Posts13Curtis Anderson
-
First post 11/30/16,Last post 12/05/16Hi there Everyone I am new with smart sheet and i work on a Engineer firm. I am encharged of the design department and i was wandering if it would be wise to make a sheet ony to this department. Or making a sheet to work with all depa…Archived 2016 Posts125Pablo Lleras
-
Closed Tim Abernathy 1 view 5 comments 0 points Most recent by J. Craig Williams Archived 2016 PostsFirst post 11/29/16,Last post 11/30/16To All, I am trying to build the Smartsheet as a service schedule. One of the may problems i have right now is trying to add up hours that the technician has worked. Im looking to count the number of hours thats been assigned and pr…Archived 2016 Posts15Tim Abernathy
-
First post 11/29/16,Last post 11/30/16I can't seem to find a way to set an alert if the Created Date changes. This would essentially only alert me when a user filled out the web-form and not if someone changed the contents of the row. I have an employee that needs to know w…Archived 2016 Posts11D Domine
-
Closed Jessica J. Myers 14 views 5 comments 0 points Most recent by Scott Willeke Archived 2016 PostsFirst post 11/29/16,Last post 12/12/17Hi Everyone - Have any of you used the new Salesforce/Smartsheet integration with project plans? I see and understand how it can push and pull data as reports between the systems, but I need to figure out how to take a cell in Smartsh…Archived 2016 Posts145Jessica J. Myers
-
First post 11/29/16,Last post 11/30/16Is there a setting or a formula to convert the standard yy in smartsheet to yyyy?Archived 2016 Posts173David Skinner -
First post 11/29/16,Last post 11/30/16I have a sheet that lists bugs and it has a 'Created Date' column (not a system column, just a date column). I need to generate a report of all issues that are 'Open' and 30 days old. I can check for 'Open'. But I wasn't able to find a wa…Archived 2016 Posts323Rohit Rao -
First post 11/29/16,Last post 12/04/16In my Resource View following deleating a sheet now have "another sheet" which i cannot get rid of. This shows my resource 200% now Any thoughts?Archived 2016 Posts152Grant Simpson
-
Closed Linda Woodworth 98 views 10 comments 0 points Most recent by Richard Rymill SBP Archived 2016 PostsFirst post 11/29/16,Last post 12/01/16I am new to Smartsheet in a company with limited knowledge about the features. We use a combination of sheets and a web form for 'ad-hoc' requests that are managed in a queue. In the queue, there is a "Due Date" column. This d…Archived 2016 Posts9810Linda Woodworth -
Closed Alison Van Pelt 12 views 1 comment 0 points Most recent by J. Craig Williams Archived 2016 PostsFirst post 11/29/16,Last post 11/30/16I have a very specific need to a time intensive schedule that requires time of day (TOD) to calculate based on predecessors. Currently I have been manually entering TOD of Start Time and Finish Time in general columns but would prefer the…Archived 2016 Posts121Alison Van Pelt
-
Closed Alfonzo Angulo de la Cruz 14 views 2 comments 0 points Most recent by Alfonzo Angulo de la Cruz Archived 2016 PostsFirst post 11/29/16,Last post 11/30/16Hello, I am counting the children of selected check boxes and then seting a ball color with formula bellow: =IF(COUNTIF(CHILDREN(Comp15:Comp17), 0) = 2, "", IF(COUNTIF(CHILDREN(Comp15:Comp17), 0) = 1, "Red", IF(…Archived 2016 Posts142Alfonzo Angulo de la Cruz
-
First post 11/29/16,Last post 11/29/16Just got off the phone with support and was told we could not take our timeline down to hours. We are going to look into our purchase to see if we purchased the right application. Otherwise how do you make a schedule work?Archived 2016 Posts21Tim Abernathy
-
Closed J. Craig Williams 37 views 4 comments 0 points Most recent by Chris McKay Archived 2016 PostsFirst post 11/29/16,Last post 11/22/17I'm trying to retrieve the latest created date and compare it to the date-time. I was expecting to get a date, not a date-time, and that would be OK. =MAX(Created:Created) returns 11/29/16, which is what I expected. However, c…Archived 2016 Posts374J. Craig Williams -
First post 11/29/16,Last post 11/30/16Hi, Smartsheet friends! I am creating a Sight that will include various metrics for four different states. I have four PNG files with icons of each state shape. What I would like to do is have the data for a particular state appear on t…Archived 2016 Posts291kcain
-
Closed John Sneddon 20 views 5 comments 0 points Most recent by J. Craig Williams Archived 2016 PostsFirst post 11/29/16,Last post 11/29/16Does anyone know how to change the % complete colour in a Gantt chart? The colour of the colour bar and the % complete are too close and I would like a bit of contrast. ie blue colour bar and yellow % complete.Archived 2016 Posts205John Sneddon
-
First post 11/28/16,Last post 12/02/160down votefavorite I'm attempting to call the smartsheet.com api and read the JSON data from a list sheet request. Im new to API's so I'm certain I'm missing much with my code. Here is what I have so far: <cfscript> apiURL = …Archived 2016 Posts163NoryB
-
Closed Paulina Raygoza 1 view 1 comment 0 points Most recent by J. Craig Williams Archived 2016 PostsFirst post 11/28/16,Last post 11/28/16Hello, I'm having trouble with my nested formula and activating the Red, Green, Gray, Yellow ball based on the % compelte column. =IF([% Complete] = IS BLANK, activate the RED ball =IF([% Complete] = less than 100%, activate the…Archived 2016 Posts11Paulina Raygoza
-
First post 11/28/16,Last post 11/29/16Has anyone created a timesheet for tracking/recording billable hours towards specific projects.Archived 2016 Posts342elh
-
First post 11/28/16,Last post 03/08/17Hello! I have been researching how to use update requests to send automatic messages to different users within a database concept I am developing; however, I have run into a few gaps, so here is my update request wish list! :) 1. …Archived 2016 Posts2710KPKC
-
Closed Chris Easterwood 24 views 4 comments 0 points Most recent by Mark Johnson1 Archived 2016 PostsFirst post 11/28/16,Last post 08/07/17I have a report section in a sight including a GANTT chart. The report itself displays the GANNT starting at the first task start date or today with the GANTT paramter. When viewing the sight, the GANNT always seems to start in January. Th…Archived 2016 Posts244Chris Easterwood