Using Smartsheet
Archives for June 2018
Discussion List
-
First post 06/30/18,Last post 06/30/18I am new to Smartsheets and new to project management. Is there a smart sheet course that I can take that caters to a project manager in training? The videos I am finding are not quite descriptive enough for me and are only about 5 minut…Using Smartsheet141LorraineRamos -
First post 06/29/18,Last post 10/02/18Hi, i need to join 2 columns. First column is the City Name and second is the Numbers. I got it to work but I only need the first 3 digits from the City : =JOIN(City1 + Number1) comes out CITYNAME3462 I need to show up CIT3462 thank you …Using Smartsheet122Patricia Worth -
First post 06/29/18,Last post 10/03/19Hi Is it possible to sum the counts of specific cells on different rows in the same sheet.All the cells are in the same column. Thanks McneilUsing Smartsheet3904McneilOMC
-
First post 06/29/18,Last post 06/29/18We have a few questions: * When our users are entering data in a form, is there a way to default certain fields based on other entries? * When users enter data, we only want them to see their submissions and not those of other companie…Using Smartsheet782bzamborski
-
First post 06/29/18,Last post 06/29/18I'm looking for a change control form with workflow for approval. It should be tailored for I.T. Surprisingly I can' seem to find one in Smartsheet. Does anybody have a good one?Using Smartsheet11Chadwick W
-
First post 06/29/18,Last post 07/03/18In the past month or so, when I make changes to data in a sheet using the IOS app, those changed values become hyperlinks to the word. For example, if I change a cell value to the word "other", it makes the value in Excel "…Using Smartsheet121ScottW
-
First post 06/28/18,Last post 06/29/18Hello smartsheet community, I am having some serious difficulty getting a COUNTIFS formula to work based on if a row in another sheet meets a data criteria. My COUNTIFS formula works right now when referencing another sheet, but I…Using Smartsheet762mwiggins
-
First post 06/28/18,Last post 07/02/18Hi Everyone, Is there such a thing as an "if" statement then link cells? If cell has check mark link these cells to a different sheet.Using Smartsheet13Jgrinde27711
-
First post 06/28/18,Last post 06/28/18Any update on adding virtual "sticky notes" to an SS? This was discussed back in 2016, but maybe there has been some movement? For example, a "sticky note" to a page to update viewers that the page is being edited w/co…Using Smartsheet302tross
-
First post 06/28/18,Last post 06/29/18Question- We would like to export the calendar to Google Calendar. I am familiar with the publish feature but it appears that it will only create a new calendar and can't be added to an existing Google Calendar. 1. Is this correct? I wo…Using Smartsheet11SS IT
-
First post 06/28/18,Last post 06/29/18I use smartsheet to keep track of project stages, I have 5 stages of the lifecycle all sorted by a different color. Is there a way to organize the rows so when that stage is reached, the row automatically moves to the bottom of the next se…Using Smartsheet221kmeisner52941
-
First post 06/28/18,Last post 06/29/18I receive this error when trying to install Smartsheet in Microsoft Teams. Any ideas what the problem is? An unexpected error has occurred. Try again and contact [email protected] if the problem continues. Cause: java.lang.Negativ…Using Smartsheet51donald.milne52931
-
First post 06/28/18,Last post 06/28/18Does anyone know of an easy way to see a report of licensed users and the last time they: Created a Smartsheet Accessed a Smartsheet I'm trying to clean up our licensed users because I don't think the licenses are distributed properly. …Using Smartsheet761bzamborski
-
First post 06/28/18,Last post 10/09/19I've created several project management files (sheets, reports, dashboards). How can I save these as a template set (package) for others in my organization to use/download? Or is it save as a workspace??Using Smartsheet64910rlakin52911 -
First post 06/28/18,Last post 05/17/19Hi I wonder if anyone might be able to shed some light on an issue I'm experiencing. I'm a new Smartsheet user so I could well be doing something wrong or expecting Smartsheet to work in a way that it doesn't. I'll set out the issue below…Using Smartsheet4105Andy Skinner
-
First post 06/28/18,Last post 06/28/18HI, New user to Smartsheet and I wonder if it's possible to download an excel copy of a document with highlighted changes? I know how to use the highlight feature, but it would be really useful to be able to have these on the export copy.…Using Smartsheet241PaulaFH
-
First post 06/28/18,Last post 03/07/19Hi, I have a schedule (created from Project template (aka Gantt chart)) where I have a section which is repeating several times in the schedule. Inside of a section I have dependencies linked using Predecessor field which do not point out…Using Smartsheet1902jkurik52881
-
First post 06/28/18,Last post 06/29/18Hello, As you can probably see from the title I would like to transfer everything within a workplace to a new owner. This includes templates, sheets, reports and dashboards, how would one go about doing this? Kind regards AntonUsing Smartsheet111Anton
-
First post 06/28/18,Last post 07/08/20Hi, I created a project timeline in SmartSheet. The today's date is indicated with a dotted line in Gantt view as well as a report created based on the project sheet. However, today's date was not shown when I included the report in a d…Using Smartsheet19710FrankW
-
First post 06/27/18,Last post 07/11/18Hey Everyone, I'm trying to create an overall project status similar to the one displayed in the "Maximize Your Smartsheet Experience" webinar. https://www.smartsheet.com/videos/maximize-your-smartsheet-experience?frame=0&na…Using Smartsheet2852Brian Davis -
First post 06/27/18,Last post 06/28/18I would like to be able to set something up that, when a field is checked, the latest attachment (or at least a link to the attaschents for that row) gets sent to "contact in column"Using Smartsheet1022ndjabiras
-
First post 06/27/18,Last post 06/28/18Hi There, Does anyone know a way to copy rows and columns from Smartsheet and keeping formatting to a Google Doc. It is part of a workflow we have and it works with Google Sheets...just want to use SmartSheet for the upcoming project??? …Using Smartsheet21amy52791
-
First post 06/27/18,Last post 03/08/19I know that users have been clamoring for this shortcoming (the lack of support for effort driven tasks) to be addressed since 2015, but this is the first time that it's been a must-have for one of my clients since I began using Smartsheet…Using Smartsheet2364Darryl R.
-
First post 06/27/18,Last post 06/28/18For example. An email has to go out every Tuesday to all employees starting from say July until September. Or a teaser to be posted on social media on specific dates. July 2, July 10 July 14 and July 18. So basically I need to have multipl…Using Smartsheet351sugandha.makker52746
-
First post 06/27/18,Last post 06/28/18Hi, I can't be the first to have asked this, but I have not found anything on the forums or community- I really want to be able to add week numbers to the top lines of a gantt. This would be very helpful, particularly when working with re…Using Smartsheet452PromagroupUK
-
First post 06/27/18,Last post 06/27/18Hey, I have been making some project programmes for my boss to present and there are occasional (seemingly random) lines running down the gantt chart. Some are at the end of a week some are at the start of the week, they are all of diffe…Using Smartsheet521PromagroupUK
-
First post 06/26/18,Last post 01/21/20The Activity Log properly logs the system users and their activities. What shows is the user's name and the activity info. I notice however, that several entries in the log lists "Publised User" as the person whose acivity is tr…Using Smartsheet1263hcosta52671
-
First post 06/26/18,Last post 06/27/18Trying to figure out how to build this formula and I have tried multiple things. Here are the conditions: I have a "Contact Aging" column that tells me how long its been from date the inquiry was acquired to today's date I hav…Using Smartsheet1411MPow
-
First post 06/26/18,Last post 06/26/18I created a sheet to put my data in and created a bunch of charts tied to it. For example, each row represents that week's data. BUT . . . as I add new rows of data for new weeks, I'm finding I have to re-establish the data field for the…Using Smartsheet621Rainyvanc
-
First post 06/26/18,Last post 04/13/20Hello. I'm trying to create graph widgets for a yearly KPI report and would like the colors of the individual months to be conditional based on if target was met or not. The only color option I see in smartsheet is for the individual serie…Using Smartsheet992kdeane
