Using Smartsheet
Archives for January 2019
Discussion List
-
First post 01/31/19,Last post 02/05/19I am moving a complex (static) spreadsheet to Smartsheet! One of the key drivers ensures that we show the date and the fact that it is NPI. In the Excel spreadsheet we have numerous columns (about 11 years but moving forward it will not …Using Smartsheet132Florence Nickerson -
First post 01/31/19,Last post 02/01/19Hi, I am trying to move my company away from scheduling via excel and get it onto a live panel where everyone can see who is doing what and when and most importantly with what equipment. Hence I'd like to get input from the community on w…Using Smartsheet461ACV
-
First post 01/31/19,Last post 01/31/19Is it possible to post a dashboard to your desktop? Being the owner of several dashboards, I would like to make it easier (if possible) for the editors to access them. I was looking (hoping) for a way for them to post their individual da…Using Smartsheet12Mykul69
-
First post 01/31/19,Last post 02/01/19I am looking to send a set Update Request to everyone on a project that has an assigned task that shows the Start Date in the past. I further would like it to group all their tasks so they don't get 10 emails if they have 10 past due task…Using Smartsheet261Gwisecarver -
First post 01/31/19,Last post 02/25/19Is there a way to pull a person's name from a sheet and have that auto-fill into the message sent with an update request? For example, I have a sheet that manages group membership. An Update Request is automatically sent to each new group…Using Smartsheet154dianay
-
First post 01/31/19,Last post 02/26/19Is there a way to auto populate a cell based on the date that an update request is sent? I would like the cell (a date field) to auto fill with the date that the update request is sent. The update request is sent automatically based on ot…Using Smartsheet25dianay
-
First post 01/31/19,Last post 02/01/19Can I create parent and child rows in all columns or just the primary column?Using Smartsheet12Heather O
-
First post 01/31/19,Last post 02/01/19Hi, While I was working on a row, adding data, I notice another user was viewing the sheet. I proceeded to complete my row and saved it. Few minutes later it was gone. The other person somehow was using the same row ant the same time a…Using Smartsheet46GetITDone -
First post 01/31/19,Last post 02/12/19I am pulling in issues based on certain epics. All issues have been added into future sprints but the sprint start and end dates are not sourcing into my SmartSheet. Only issues that in the current or past sprints are sourcing dates. A…Using Smartsheet21Sarah McMorrow -
First post 01/31/19,Last post 02/05/19We use Smartsheet for forecasting budgets per team. Each team has its own sheet with each line item that rolls up to sheets, reports, and a dashboard (with graphs and metrics). The columns represent both forecast and actual money spent pe…Using Smartsheet146jcotten -
First post 01/31/19,Last post 01/31/19I like to collapse my rows to just see the parent row when the child tasks all reach 100% (I don't want the rows to to be removed from the report - I know it's an option not to display them when they reach 100%. It seems that, when I coll…Using Smartsheet161Jennifer Levey
-
First post 01/31/19,Last post 01/31/19Why is it that after you hide several columns, you only have the option to unhide ALL? Or am I being silly and missing something?Using Smartsheet11810LLaCosta -
First post 01/31/19,Last post 02/11/19Hi. Our group within the company has been using smartsheet for a number of years. Recently corporate has launched our corporate account and we need to cancel our existing account and migrate all the data into the new corporate account. …Using Smartsheet351willettemd76871
-
First post 01/31/19,Last post 01/31/19Hello Smartsheet! What is the reason of colouring checkboxes bright blue? Don't you have any other more important jobs to do? Are colours the most important for your users? If you like to be so cool, then please let us choose alittle bi…Using Smartsheet137Marcin P -
First post 01/31/19,Last post 02/27/19Can we provide row access to a group of people rest other cannot view or tough those rowsUsing Smartsheet18Jimmy
-
First post 01/31/19,Last post 01/31/19Hi All, Does anyone knows who is such user? I have noticed such activity for the very first time. (Image)Using Smartsheet21Marcin P
-
First post 01/30/19,Last post 01/31/19Hello, I need to multiply and the divide two columns but one of them already is a formula. It's a simple sum of children which for this example is 3 and in column 1. The next number is manually entered into column 2 which is 48776. If I en…Using Smartsheet176MrMike
-
First post 01/30/19,Last post 02/07/19I am frustrated with the new "View" SmartSheet has created. I switch between many sheets during the work day and depended on the tabs across the top of my screen. Now I have to search through the left hand view and it takes a l…Using Smartsheet144j.green -
First post 01/30/19,Last post 01/30/19Is there a way to click, within the actual email notification, in order to approve a Website Change Request? I don't want to have to open ('View Request') in order to approve. Thanks.Using Smartsheet702bmelland
-
First post 01/30/19,Last post 01/31/19When I send attachments from a sheet that has many attachments it is sometimes hard to find which line that particular item came from, which would be very helpful. Is it possible to add the source line number in the automated email? And i…Using Smartsheet121frobison14816
-
First post 01/30/19,Last post 02/21/19Conditional formatting using a date, is not taking into account the local account regional settings/timezone and appears to be using a default time zone. As conditions like change the color of a cell if the date in that cell = Today, is s…Using Smartsheet151PeterG
-
First post 01/30/19,Last post 01/31/19Good Afternoon, I'm trying to add columns that only contain text. I have a column where the users insert "issues" that they have with that particular line item. At the bottom of the sheet, I need to have a running total of how…Using Smartsheet5694Mykul69
-
First post 01/30/19,Last post 02/14/19Hi all, I am unsuccessfully trying to create a formula for the following RYGG column: Column [Project at Risk] with the RYGG: * If [PROJECT START] (date) is more then a day over I want the [[email protected]] to display "RED" ball …Using Smartsheet162isalinosousa
-
First post 01/30/19,Last post 01/31/19I have a parent row where its high level description of task, The clhildrens rows are action items and next steps that have unique formatting. I would like collaborators with minimal SS experience to easily be able to add children row with…Using Smartsheet613bradfurt13
-
First post 01/30/19,Last post 01/30/19This might be incredibly simple but I can't seem to find it already answered! Sometimes when I set a Finish to Start predecessor, the auto-filled "Start Date" is the same date as the predecessor row instead of the following busi…Using Smartsheet23Kaitlynn Sumpter
-
First post 01/30/19,Last post 01/30/19Hit a brick wall, but I'll try to explain as best I can. Cell1 has a formula for a NUMERICAL sum for a row across [Column A] + [Column B] Cell2 has a formula to return TEXT based on value of a single cell in [Column C] My goal is to hav…Using Smartsheet11Dave-Cisco
-
First post 01/30/19,Last post 03/01/19I've got an auto-number column in one of my sheets, which has data from an excel sheet that I used prior to smartsheet. Most of the numbers in the auto-number column were from historical data and needed to be identical to that excel sheet,…Using Smartsheet2804Interrogation
-
First post 01/30/19,Last post 05/31/19I downloaded an example dashboard which tracked multiple projects. Looked good and decided to build my dashboard to match example. Example dashboard has a Rich Text Widget which has multiple formats within. However when I try to use the…Using Smartsheet678Paul Stell
-
First post 01/30/19,Last post 01/30/19Hi I would like to be able to create a column drop down with our 8 of our staff names and be able to select multiple drivers in one column is this possible how do I do this? For example David, Richard, Pablo, Sarah And be able to selec…Using Smartsheet913itransitexpress
-
First post 01/30/19,Last post 01/30/19I'm trying to add a user's email as a secondary email, but it's telling me the address is already in use. I can't however, find the other address as a user account. is there a way of finding out if it's being used as a secondary somehwere …Using Smartsheet41Garmon D