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 May 2017
Discussion List
-
First post 05/31/17,Last post 06/01/17We recently lost our admin and we had to transfer owner to a new admin. it worked great for most of the workspaces. however, we have 87 sheets in a new folder called "Transferred from [email protected]". and the folders that …Archived 2017 Posts172Del Rae -
First post 05/31/17,Last post 06/01/17s it possible to create a formula or a conditional formatting rule that would automatically highlight any child rows as they are created and/or based on a specific term or text in a column of the parent row?Archived 2017 Posts522CcHPal
-
First post 05/31/17,Last post 09/26/17Hello! I have a range of numbers I need to include in a logic function, specifically: < 3 = XS 4-8 = S 9-16= M 17-39= L >40= XL This is my logic string, and I've used a similar one in a previous sheet, but I know my number r…Archived 2017 Posts289Shalise
-
Closed nic.stransky 232 views 1 comment 0 points Most recent by Shaine Greenwood Archived 2017 PostsFirst post 05/31/17,Last post 06/01/17In the example below, I have a column named "Task Name" which contains "Version 1.0" and a column named "prefix" which contains "1.0" In the row Task A, I want to pull in the value "1.0". …Archived 2017 Posts2321nic.stransky
-
Closed jose.castellon15981 3 views 1 comment 0 points Most recent by Shaine Greenwood Archived 2017 PostsFirst post 05/31/17,Last post 06/01/17Good day everyone, I'm looking to perform the following using a webforms. When a webform is populated and a specific dropdown choice is selected, in smart sheet I want that row to be relocated to a specific category. For example: 1. …Archived 2017 Posts31jose.castellon15981
-
First post 05/31/17,Last post 06/01/17I am using Smartsheet for as an event planning checklist. I have enabled the dependencies and predecessors features. I have also created a status column with the following four options each each task in the Smartsheet (Task not applicable,…Archived 2017 Posts61Brian Davis -
First post 05/31/17,Last post 06/01/17FORMULA HELP NEEDED (See Screenshot) I need help creating a formula to show: IF "Actual Time" Column is 10% more than "Estimated Time" Column, then "ERP vs ACTUAL" Column shows "DOWN" Symbol IF N…Archived 2017 Posts414Laura -
Closed Victoria Ganuelas 16 views 4 comments 0 points Most recent by acalcaterra Archived 2017 PostsFirst post 05/31/17,Last post 09/29/17I have a series of columns Datameshed using the Cell link option but when I go back to the target sheet, there are random cells that do not show cell linking even though there is content in that cell in the source sheet.Archived 2017 Posts164Victoria Ganuelas
-
First post 05/31/17,Last post 06/01/17I am having difficulty with a calendar calculation that I use to calculate planned completion %. When dates have more than 30 days or when a non-working (holiday) is part of the month, the formula is not working as intended. Below is the …Archived 2017 Posts113Katja
-
First post 05/31/17,Last post 05/31/17friends, is there a quick n easy way to return a blank in a cell instead of #divide by zero pls see screenshot. ta, Si. (Image)Archived 2017 Posts2032Si Spence -
First post 05/31/17,Last post 06/02/17Hi sir I am new user o smartsheet and i have a quiry .. please help meArchived 2017 Posts22sanjay09
-
First post 05/31/17,Last post 06/02/17Hi, anyone experienced this? I have a master sheet with a column that contains all the hyperlinks to the subsidiary sheets. The links have gone overnight! Cell history shows they were updated by a cell link user, but the cells aren't lin…Archived 2017 Posts9727Roland Horwood -
First post 05/30/17,Last post 05/31/17To The all-knowing, How do I condition a column to allow for currency PLN, when PLN does not appear in the currency option list? Thanks, Si.Archived 2017 Posts162Si Spence
-
First post 05/30/17,Last post 05/30/17Hi; Is there a limit to the number of entries in a drop down list? Would a list of 1200-1500 names have an impact on performance? We don't need validation or conditional formatting (e.g. red for a value is entered that is not in the li…Archived 2017 Posts1902Andrew Miller
-
Closed SmartSheetNoob 2 views 2 comments 0 points Most recent by MichelleMWatkins Archived 2017 PostsFirst post 05/30/17,Last post 06/04/17Hey Everyone, So glad I found this community! I am currently trying to create a formula and am struggling severely with it! :( I have multiple tasks that need to be performed. Task 1 may take X days, once its finished and only once …Archived 2017 Posts22SmartSheetNoob
-
First post 05/30/17,Last post 05/30/17Simple, but important question when dealing with the API. Are the ID's for each column, row, and sheet unique across all workspaces or are they only unique relative to the environment they are in?Archived 2017 Posts782Nathan Reid
-
First post 05/30/17,Last post 09/21/17Fellow Smartsheeters We have a process that necessitates the approval of certain managers at certain gates during the process. What is the most robust way that you have found to ensure approval is received and not just ticked off 'accide…Archived 2017 Posts744Si Spence
-
First post 05/30/17,Last post 05/31/17Hi, I am just evaluating smartsheet and have just pulled togeather a test project sheet and I am noticing that the Parent and Sub Parents are not rolling up in the Project Duration column Please see snapshot below Regards Cathy (Ima…Archived 2017 Posts182Cap -
Closed Carlos Santos 44 views 1 comment 0 points Most recent by Shaine Greenwood Archived 2017 PostsFirst post 05/29/17,Last post 05/30/17Hi. 2 similar situations: 1) I created a group with 2 users (me and one other licensed user) then I created a new workspace and shared it with that group (editor - can share) but now I can create sheets within the workspace but he cannot…Archived 2017 Posts441Carlos Santos
-
First post 05/26/17,Last post 05/30/17I'm trying to use the SUMIF function to calculate the total in Column A when the date in Column B is less than or equal to 10/2/17, but haven't been able to make it work. Please advise.Archived 2017 Posts1091Angelea Much
-
First post 05/26/17,Last post 05/30/17Full disclosure, I just initiated a trial of Smartsheets and haven't yet taken the time to learn its features; this might be as easy as copy paste. Is there a way to create a form from a text file or spreadsheet list? I have a long list o…Archived 2017 Posts131joshcqg
-
First post 05/26/17,Last post 05/30/17I'm trying to expand on this formula that triggers a recurring reminder (explained here: https://www.smartsheet.com/blog/support-tip-recurring-reminders): =IF([Flag1]1 = 1, TODAY(), "") I want the return value to equal today i…Archived 2017 Posts21Beka
-
First post 05/26/17,Last post 05/26/17Need formula to calculate a date: Spreadsheet has (3) Columns as follows: Cal Type (drop down) with 2 options - In-house or Third-Party Next Cal Date: Date Reminder Date: Date Would like formula to calculate the following If/then sce…Archived 2017 Posts125rbarnes15506
-
First post 05/25/17,Last post 05/29/17Hi, I am new to Smartsheet (have used MS Project) I am looking how the following would be best to implement. An overall task may take say 15d's out of that 15d's an assigned resource may only be required for 1 day out of those 15d's. …Archived 2017 Posts743Cap
-
Closed jennifer.cooper15596 131 views 22 comments 0 points Most recent by Tara Seewald Archived 2017 PostsFirst post 05/25/17,Last post 04/24/19I have not been able to find information on how to create a control and/or burndown chart in Smartsheet to track the cycle time of tasks as they pass through different statuses and the remaining work. I was planning to add columns and cre…Archived 2017 Posts13122jennifer.cooper15596
-
First post 05/25/17,Last post 06/07/17I have a one date upon which all other due dates are calculated. We have holidays set up for the account. I need the due dates to fall on the weekday PRIOR to the due date if it is a weekend or holiday. It appears the Workday and Networ…Archived 2017 Posts1393ker9
-
First post 05/25/17,Last post 05/26/17I see posts from 2015 but no recent postings concerning changing the font size when printing a sheet. Is there a way to change the font size when printing? Depending upon the type of sheet and number of columns, the font is too small for…Archived 2017 Posts422Tina Conrad
-
First post 05/25/17,Last post 05/25/17We track all our promos on one sheet. Some of them run one day, some of them run for several days, some of them run more or less permanently. I need a view of everything running on a given day. The filters do not appear to permit this. …Archived 2017 Posts121Wolf
-
First post 05/25/17,Last post 05/25/17We have 5 events throughout the year that each have their own sheets. These events run: December to February January to March March to May April to June August to November. Is there a way to see what parts are over lapping? Ideall…Archived 2017 Posts521Ann Alexandrowicz
-
Closed Nikita Chernovalov 2 views 3 comments 0 points Most recent by Shaine Greenwood Archived 2017 PostsFirst post 05/25/17,Last post 06/05/17Dear Colleagues, I have come across the error message reading that the newer version of the process already exists when I am editing my workflow. Could you please advise how to avoid such error?Archived 2017 Posts23Nikita Chernovalov