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 October 2017
Discussion List
-
First post 10/31/17,Last post 11/06/17Hello, I'm needing to create a sheet where a task has a start date of say, 11/1/2017, and then I need to be reminded of something 30 days from the start date, 11/31/2017. Can someone help with the formula for that? (Column A would be &q…Archived 2017 Posts154Dana L -
First post 10/31/17,Last post 11/01/17i'm looking at whether to use survey monkey or smartsheet for a client survey. I'd like to be doing regular surveys so am thinking smartsheet. Has anyone used it for this purpose? What should I know before I start? Is it better than surv…Archived 2017 Posts352Sally Osborne
-
First post 10/31/17,Last post 06/13/18i have to organise a list of passengers on a mini-bus. Row 6 contains a list of those passengers, with the first column after the primary column containing a count function telling me what the total number of passengers there are in row…Archived 2017 Posts14213joe taylor
-
First post 10/31/17,Last post 11/09/17Hi there, I need a formula that will round UP time, for example if I have 2.5 hours worked I would need the column to round up to 3 hours. I have an hours worked column - 2.5, and a column of time paid (which needs to round up to the ne…Archived 2017 Posts469Melissa Kesler
-
First post 10/31/17,Last post 11/01/17I am trying to have a column with dropdown choices auto-populate a value in the next column. If IP-A is chosen in the AssetType column, the TotalHours column should display 1. If IP-D is chosen the TotalHours should display 15. I was thin…Archived 2017 Posts912OneL
-
First post 10/31/17,Last post 10/31/17Can somebody help me how to manage the Smartsheet because this is my fist time using it, so now it's like i cant do anything on it actually i don't know anything here......can somebody help me please.Archived 2017 Posts22CLEMENT
-
First post 10/31/17,Last post 11/06/17Can you view all form results in the same format as the form? In other words, seeing the form with answers provided (scrolling down through questions) rather than results being displayed across like a spreadsheet?Archived 2017 Posts393jcampf
-
First post 10/31/17,Last post 11/01/17Hi, when using the Smartsheet Outlook add-in, one of the entries is a contact list selection, whoever no contacts that I saved in the original sheet are pulling through in Outllook. Any idea why? Thanks, OJArchived 2017 Posts21OJ93
-
First post 10/31/17,Last post 11/01/17Hello, I am trying to create a status column which updates automatically based on the following criteria: * Green (Task is Complete): “% Complete” column = 100% * Yellow (Task is In Progress): Today’s Date is less than “Planned End Date”…Archived 2017 Posts41allisona
-
First post 10/31/17,Last post 10/31/17Hello, is there a maximum number of submissions you can collect from a form if you have a free account or is there a max no. of times you can send out one particular form?? Thanks!Archived 2017 Posts26Heidil
-
Closed J. Craig Williams 14 views 2 comments 0 points Most recent by J. Craig Williams Archived 2017 PostsFirst post 10/31/17,Last post 11/01/17I thought I had written an enhancement request for this before, but I have no record of it. I'd like to be able to retrieve the row number (not the ID, the number) using a formula. Some use cases: In this thread (https://community.smart…Archived 2017 Posts142J. Craig Williams -
First post 10/30/17,Last post 10/31/17I have projects with 3 milestones, call them A, B, C C is dependent on B which is dependent on A. C is a critical completion date. If either A or B is late, C is automatically late and that is very bad. If A or B is late by X number of…Archived 2017 Posts22jsnodgrass
-
Closed Peter Smith 2 views 2 comments 0 points Most recent by Richard Rymill SBP Archived 2017 PostsFirst post 10/30/17,Last post 10/31/17Hi, I have a task that need to monitor status of monthly building reports to clients. The process is like as following: 1. Form department will generate building reports (each person in Form department has their own portfolio).…Archived 2017 Posts22Peter Smith
-
First post 10/30/17,Last post 10/31/17I cant see it for looking, this formula should work (attached0 (Image)Archived 2017 Posts117Heath Sanders
-
First post 10/30/17,Last post 04/26/19Hello, I'm trying to create a monthly report from quarterly data. I want a formula that will count how many projects went live in a given month from a column of dates. In the screen shot, I want to put a formula in the blue cell that tall…Archived 2017 Posts21511ShannonT
-
First post 10/30/17,Last post 11/01/17Seeking an independent Smart Sheet Consultant to begin work no later that the 31st October 2017 6:00 PM GMT You should be able to screen share and use our already uploaded excel spread sheets to create reports.and sights. You should be a…Archived 2017 Posts333Johnie-2017
-
First post 10/30/17,Last post 03/15/19Hi, When I export a sheet with a Gantt chart to MS Project, I loose all the data on task duration, dates, predecessors, etc. Is there a way to export keeping this project information intact? Thanks, DavidArchived 2017 Posts1623papercontracts
-
Closed [email protected] 12 views 2 comments 0 points Most recent by [email protected] Archived 2017 PostsFirst post 10/30/17,Last post 11/01/17Hi All, Basically I want to know how I can re-fire alerts and notifications that failed due to errors and have been subsequently edited. Example described below We are testing a new smartsheet using alerts and notifications and a multi …Archived 2017 Posts122[email protected]
-
Closed Heath Sanders 3 views 2 comments 0 points Most recent by J. Craig Williams Archived 2017 PostsFirst post 10/29/17,Last post 10/31/17Hi Team, If "Save as New... gives you "Date & Formatting Options" to tick and untick what you want. Sheet data & Formatting, Cell linking, Sheet filters and forms, attachments etc. etc. Why cant there be an opti…Archived 2017 Posts32Heath Sanders
-
First post 10/28/17,Last post 10/30/17I created a notification and saved the sheet as a template. When using the template to create a new sheet, it retains the notification but not the email address in the notification. I set the original sheet to use any email address but …Archived 2017 Posts247ker9
-
First post 10/27/17,Last post 10/29/17I am close to creating a calendar (report that only shows activities across sheets with duration < 15d), but have run into an issue where certain activities or milestones are showing up twice because they are linked between sheets. Othe…Archived 2017 Posts201c_berg
-
Closed Erik D. Schiller 1 view 3 comments 0 points Most recent by J. Craig Williams Archived 2017 PostsFirst post 10/27/17,Last post 11/03/17We have a sheet that automatically generates a job number based on how someone fills out a web form: =IF([CLIENT - REGION]1 = "HMA - Hyundai Motor America", "HMA", IF([CLIENT - REGION]1 = "HDAA - Hyundai Dealer As…Archived 2017 Posts13Erik D. Schiller
-
Closed Rob_US Imaging 1 view 1 comment 0 points Most recent by J. Craig Williams Archived 2017 PostsFirst post 10/27/17,Last post 10/29/17I have a sheet we are using to track payments etc with the layout is simple First Col is the Colored dots Red/Yellow/Green Cols 2 to 7 are just plain data 3 are date fields the rest are text Col 8 has the only formula = TODAY() - [Check…Archived 2017 Posts11Rob_US Imaging
-
First post 10/27/17,Last post 10/30/17Is it possible to track update requests in the mobile app? I know we can send update requests from the app. But, I don't believe we can view update requests that have already been sent. Please prove me wrong! Thanks, DustinArchived 2017 Posts135Dartwohl -
First post 10/27/17,Last post 10/27/17I currently have data which is in sheet 1 of my sample sheet attached. I am expecting an output in the format I have made in Sheet 2. The formulae that I have tried till now for the same is in sheet 3. Here is the link to the sheet : ht…Archived 2017 Posts21napson
-
First post 10/27/17,Last post 10/27/17Hi, I created a workspace, I drag the reports to the workspace and then share the reports by adding people contacts. The people can find the reports in the workspace, but when they open the reports, they are blank. Why? What shall I d…Archived 2017 Posts132TC
-
Closed Lindsey_123 114 views 4 comments 0 points Most recent by Galen Garrison, PMP, CSM, MBA Archived 2017 PostsFirst post 10/26/17,Last post 05/17/18New to smart sheet but couldn't find an answer to this question! Is there a way to add several time values to a total (ex. :15 + :15 = :30)? My goal is to sum all overtime minutes worked during the week into a running yearly total. On m…Archived 2017 Posts1144Lindsey_123
-
First post 10/26/17,Last post 10/26/17Does anybody else no longer see the option on the dropdown list to "Send a notification when a comment is added or updated"? (see red circle in image attached) I could clearly set this notification up in the past. (see blue cir…Archived 2017 Posts492tylermh -
First post 10/26/17,Last post 10/26/17Is there a way to set up one report that shows all changes the user has made throughout any/all spreadsheets in smartsheet on a reoccurring basis (daily or weekly) ? *It would be helpful if the report showed the actual line item changes a…Archived 2017 Posts31Elloria Lindley
