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 May 2016
Discussion List
-
First post 05/31/16,Last post 08/18/16I need to create a formula that if a checkbox column is blank, then a date is entered into a Start Date column which is the first of the month of todays month date. The checkbox column is checking if the row was created in 'This month'…Archived 2016 Posts342LouSnz -
Closed Amanda Williams 101 views 7 comments 0 points Most recent by J. Craig Williams Archived 2016 PostsFirst post 05/31/16,Last post 02/20/17I am creating a SS that contains a row for each event and below children for event expenses. The top/parent row calculates the sum of the children beneath it. I would like to create a Totals row that calculates the sum of all the top/…Archived 2016 Posts1017Amanda Williams
-
First post 05/31/16,Last post 06/06/16Hey new member here, are you guys planning to have an API to add graphs to sheets and sights? I've read a few posts on the topic already, is this in the works? Any ETA on that?Archived 2016 Posts43Gareth Mensah
-
First post 05/31/16,Last post 06/02/16I'm trying to take a list of dates and associated activities - potentially up to 15 per day -- and display them in a calendar format...either traditional or agenda layout. I have curriculum maps -- material we will cover each day for 6-8…Archived 2016 Posts471Dina
-
First post 05/31/16,Last post 06/23/16Hi I am looking for a formula that will show in the parent an RYG colour based on the children. If there are any Red in the children, I want to show Red in the parent, If there are no Red but there are Yellow in the children, Sho…Archived 2016 Posts368Mark Baldwin
-
First post 05/31/16,Last post 06/01/16Hi there, is there a way to remind users to update requests if they haven't done it. Thks PeterArchived 2016 Posts23Peter -
Closed J. Craig Williams 4 views 2 comments 0 points Most recent by J. Craig Williams Archived 2016 PostsFirst post 05/30/16,Last post 05/31/16At the risk of stealing Smartsheet's thunder, I would like to personally thank Travis Hannon for all the great answers, insightful comments, and general enthusiasm to help the Community (and me) with all problems great and small. I'm s…Archived 2016 Posts42J. Craig Williams -
First post 05/30/16,Last post 06/12/19Hi, Refer to below image, there are few collapsed columns - I'm not able to open them by draging the edge of the column, any tips how to expand them? thanks. (Image)Archived 2016 Posts1573woerrong
-
First post 05/30/16,Last post 05/30/16I am unable to export the Gantt chart to excel. Only the values and data is being exported but not the chart itself.Archived 2016 Posts5741Shikhar Aggarwal
-
First post 05/30/16,Last post 05/30/16Hi, it would be helpful to have a duplicate row kew. This would speed up data entry very much when using similar content of a row, e.g. preparing, holding, follow up a meeting/presentation as three rows. Kind regards MichaelArchived 2016 Posts592Michael G. -
First post 05/30/16,Last post 05/31/16A few minutes ago I tried to start Smartsheet in Chrome, but got the following message: "Smartsheet is loading... It is taking longer than normal to load Smartsheet. In certain cases, a network or internal anomaly will prevent S…Archived 2016 Posts62Akos Bota
-
First post 05/29/16,Last post 06/01/16Hello, I have a sheet that I would like to convert to a template. I would like to hide several columns as they will auto calculate once a box (in another column) is checked and they are therefore unnecessary for the end user to see. Is…Archived 2016 Posts54Emily B.
-
First post 05/29/16,Last post 06/02/16I have a data set where the targets are set at the start of the year and as the year progresses actuals are loaded (through Webform) which appear on a different row. I am trying to calculate the performance each month (Actuals / Target) bu…Archived 2016 Posts132Andrew Currie
-
Closed Sergio Cavazos 3 views 1 comment 0 points Most recent by J. Craig Williams Archived 2016 PostsFirst post 05/27/16,Last post 05/28/16I am getting the following message when I am uploading a webform (Image attached) . Can anyone point me in the righ direction here? what I am doing wrong? (Image)Archived 2016 Posts31Sergio Cavazos
-
First post 05/27/16,Last post 08/01/18I'm working on a sheet that will provide me with a team breakdown and weekly breakdown based on checkboxed columns (to make it easier for the end users of the sheet). However, I can't get my formulas to work. (I'm certain that it's due t…Archived 2016 Posts374Jason Pafford
-
Closed Kristopher Varanelli 16 views 2 comments 0 points Most recent by Kennedy Stomps Archived 2016 PostsFirst post 05/27/16,Last post 05/31/16For some reason my rows are not aligned. Smartsheet used to auto-correct this issue, but for some reason it is not correcting it now. I tried refreshing, logging out, etc.. Nothing changed it. Please help. Thanks. …Archived 2016 Posts162Kristopher Varanelli
-
Closed John Stanley 29 views 6 comments 0 points Most recent by Covey.Groff96271 Archived 2016 PostsFirst post 05/27/16,Last post 07/15/19If holidays are entered in the "Non-Working Days", will there be visible evidence in the Gantt chart to reflect this?Archived 2016 Posts296John Stanley
-
First post 05/27/16,Last post 10/24/18Is there a way to globally add/delete links between sheets or does each link need to be added/delted individually?Archived 2016 Posts1910Lisa Reichnach -
First post 05/27/16,Last post 11/07/18I have a report that compiles data from multiple Workspaces. I would like to be able to include the workspace in the report as a column (just like I can include Sheet Name as a column.) Is there at least a formula that I can include in a …Archived 2016 Posts515Dave Ungar
-
First post 05/27/16,Last post 07/04/19Hello all, I am trying to see if there is a way to remove those "header" tasks from reports. I ask this because it captures dates from the sub tasks and therefore becomes duplicative in a report. I have colored these lines …Archived 2016 Posts417Tara Dolgner
-
Closed Jim Jeffcoat 14 views 1 comment 0 points Most recent by J. Craig Williams Archived 2016 PostsFirst post 05/27/16,Last post 05/27/16This time last week, my CIO asked me to look into Smartsheet. One week later I have a beta version of a project template containing 6 sheets, 3 reports, and one dashboard. I was surprised how easy it was to develop a pretty solid solution …Archived 2016 Posts141Jim Jeffcoat
-
Closed Krzysztof Żebruń 41 views 4 comments 0 points Most recent by Krzysztof Żebruń Archived 2016 PostsFirst post 05/27/16,Last post 05/30/16Hello I have tried to find a solution for one functionality, but nothing is working for me now. I'm trying to make 3 tasks Task A - is a task with fixed start and end dates. Task B - dates taken from A and C like described bel…Archived 2016 Posts414Krzysztof Żebruń
-
First post 05/26/16,Last post 09/21/16Can I request for spell check? This hasn't been an issue (or at least not raised) and I would like to keep it that way. The Chrome browser option isn't so user-friendly; no 1-click scan or doesn't automatically show misspelled words. (…Archived 2016 Posts371Jay Bautista
-
Closed Lisa Barnett 14 views 1 comment 0 points Most recent by Jennifer Dewhurst Archived 2016 PostsFirst post 05/26/16,Last post 06/01/16Ii am trying to set up an It Service Request Tracker that can incorporate the request being sent to specififc individuals for approval. In other words before a lower level user can submit a request, Mgmt needs to review and approve it. C…Archived 2016 Posts141Lisa Barnett
-
First post 05/26/16,Last post 05/30/16I am looking for a formula to collapse the sub-task rows into the parent after all sub-tasks are completed. I found a formula that will check mark the parent row after all sub-tasks are checked complete, but want to collapse when that occu…Archived 2016 Posts272Steve Langford
-
First post 05/26/16,Last post 05/30/16Is there a way to filter and do conditional formatting for odd/even numbers used from auto-number? If not, I would like to pose this as an enhancement request.Archived 2016 Posts928Jay Bautista
-
Closed Denise Quach 2 views 2 comments 0 points Most recent by J. Craig Williams Archived 2016 PostsFirst post 05/26/16,Last post 05/26/16I have a master list to track the cost of an item. Is there a way to format cells to change the font to Red or Green based on whether or not the value is higher than a previous cost? IE: In 2015 cost was $1 and in 2016 the cost rose to $2.…Archived 2016 Posts22Denise Quach
-
First post 05/26/16,Last post 06/01/16I have a sheet where the first row is populated with instructions on how to complete each column (becasue the column title text is so limited - but i digress). That row is formatted in a green color to set it off from the actual data r…Archived 2016 Posts374Jamison
-
First post 05/26/16,Last post 05/26/16I have tried to add formulas in the start date column for a gantt chart that reference a base start date cell and add a certain number of days to the start date. Is that possible? Example of the formula I am implimenting: = StarteDate…Archived 2016 Posts371Neal Kaye
-
First post 05/26/16,Last post 05/31/16I froze the column "company name" so that it and all the columns before it would follow me across the spreadsheet as I entered data. I am now wanting to indent rows below a couple new headers: "Commitments" and "Pr…Archived 2016 Posts142QElbert