Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
Project Management
Discussion List
-
First post 08/28/19,Last post 01/23/20Sheet 1: Work Scheduled (number of work units scheduled in a given month) Sheet 2: Budgeted Cost of Work Scheduled (to determine the total cost of the work scheduled in a given month) I would like to multiply a cell from Sheet 2 with the…Formulas and Functions24116JoeS -
First post 12/20/18,Last post 01/23/20I have a sheet with a list of assets. There is a pull down menu that defines the status - I need to know when the menu is set to "complete". I can do that easily with a filter - but I want to cull the entries before a specific da…Formulas and Functions888CamCrichton
-
Card View - Conditional FormattingAccepted AnswerFirst post 01/21/20,Last post 01/23/20Hi all (Andre you about? haha) I am trying to conditional format on the card view, in terms of striking through the Primary Text (Task Name) when the % Complete column = 100% This works on the grid or gantt view however does not carry ove…Using Smartsheet243Gunn_Jack
-
Answered Tucker Webb 13 views 3 comments 0 points Most recent by Richard Rymill SBP Using SmartsheetFirst post 01/22/20,Last post 01/23/20Hi Smartsheet, I have the following problem. I am a contractor that has to go around a home and take a materials count on a list of tasks say a door install, window install, etc. Anyways, I am trying to figure out the quickest and best sol…Using Smartsheet133Tucker Webb
-
First post 01/15/20,Last post 01/22/20I have rather long project sheets and several standard reports (Over Due Tasks, Tasks Due Next Week, etc) and include "Sheet Name" as a column in all. Each person is active on multiple sheets (projects), so all their assigned &a…Using Smartsheet163poweb048
-
First post 09/18/19,Last post 01/22/20I’m working on a SUMIFS formula to add/sum numbers in 2 or more separate cells based on a checkbox input in 2 or more other cells. I’m able to do so only if the number columns and the checkbox columns are next to another. Is there a way …Formulas and Functions174Sam Gold
-
Alessandro Terranova 16 views 3 comments 0 points Most recent by Andrée Starå Premium Apps and IntegrationsFirst post 01/20/20,Last post 01/22/20Hi Community, I am in the process of creating a new Team workflow and I would really appreciate to discover how to easily import Trello Custom Fields into Smartsheet. I am aware of the Trello import procedure https://help.smartsheet.com/…Premium Apps and Integrations163Alessandro Terranova
-
First post 08/10/18,Last post 01/22/20Is there a way to have a row come in automatically at the same indent level as the row above it? My top row is a parent row with calculations based on all of its children. The children rows are all web form generated and they do not come i…Using Smartsheet476RossL
-
First post 01/20/20,Last post 01/21/20Hello, I am using the following formula to represent health color for individual rows: =IF([Start Date]40 > TODAY(), "Blue", IF(AND([% Complete]40 < 1, [End Date]40 < TODAY()), "Red", IF(COUNTIFS(CHILDREN(), &q…Formulas and Functions144Adam Fink
-
First post 05/31/18,Last post 01/21/20I understand there is no way to link directly to a file from dashboard unless it is in a cloud-based storage program. Has anyone found a workaround? We don't use this kind of storage and I want to be able to link directly to files. Savin…Using Smartsheet1293Carly Sorensen -
Schedule VarianceAccepted AnswerAccepted Answer James Pflueger 21 views 5 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 01/17/20,Last post 01/21/20How can I copy columns from one template and add them to a different template? I want to add the date variance column from the Project Gantt and budget template and add them to the Project plan template. I just want a way to baseline and t…Using Smartsheet215James Pflueger
-
First post 12/07/19,Last post 01/21/20My project contains multiple sheets that need to be summarize. Each sheet has a sheet summary but since my data spans across multiple sheets, I need to combine the calculated fields in my sheet summaries to be combined (sum, average, count…Using Smartsheet642awollam105821
-
First post 02/20/18,Last post 01/20/20Is there a way to set a particular field to accept more than 4000 characters? We use SS for managing projects and the "Notes" field we have established is where we run into issues. On occasion, we need more than 4000 characters.Using Smartsheet1017KMart
-
Calculating average difference in dates between two columnsAccepted AnswerAccepted Answer Jeanice Truong 20 views 1 comment 0 points Most recent by Genevieve P. Formulas and FunctionsFirst post 01/17/20,Last post 01/20/20Hi I am trying to find the average time to complete a task without adding additional columns in my sheet. I would like to set it up in the sheet summary for easy reporting. In excel I would use the following formula. If a cell is blank th…Formulas and Functions201Jeanice Truong
-
First post 02/05/18,Last post 01/19/20When creating a project many times the comments are as much instructions, as comments. Just like this modal when creating community comments, add the ability to apply Rich Text Formatting; Bold,underline,bullets, and numbered lists. RTF fu…Using Smartsheet366Dantawn
-
First post 01/17/20,Last post 01/17/20I have multiple sheets(Representing a job) in a workspace that have conversations. I am wanting to combine all of the conversations into one report or sheet to see all of them in one sheet. Can this be done?Using Smartsheet141rwholland -
First post 03/01/19,Last post 01/17/20Hi, I am a business license user, recently, I shared the report to the people. some of them feedback, since we forget the password, when they tried to reset passowrd by click" forget password", they got the message “ the request…Using Smartsheet285hlu3680451 -
First post 01/16/20,Last post 01/16/20I have active project sheet and a separate pipeline project sheet. I have a metrics sheet that includes data on the active sheet. I see that I can create metrics from pipeline sheet in different columns. But what I want to do is create a …Using Smartsheet264Shawn Borror
-
First post 07/01/18,Last post 01/16/20We have built out a 'project portal' of sorts made of up several sheets, reports, and dashboards. I'm looking for anyone who has done the same and/or built a 'getting started guide' for customers to understand how the project will be manag…Using Smartsheet172rlakin52911 -
First post 12/05/19,Last post 01/16/20Hello, I'd like to show the number of tasks each person on my team is working on in a roll-up sheet. On all my project sheets, the 'Assigned To' column allows multiple names. When I attempt to aggregate the number of times a name appears …Using Smartsheet332lvolpe
-
First post 03/21/18,Last post 01/15/20I want to take a Smartsheet Dashboard that is interactive and put it as a web part within MS SharePoint 2016 site. I use the page viewer webpart and provide the web page link offered up when I publish the dashboard, but once I apply it, a…Using Smartsheet1132Michele Deo -
Answered C. Srinidhi Ragunathan 25 views 4 comments 0 points Most recent by C. Srinidhi Ragunathan Using SmartsheetFirst post 01/06/20,Last post 01/15/20I have few tasks in my sheet, which are not independant of other tasks. The dependencies have been swtiches on in the gantt view. Is it possible to add a delay to these tasks without manually changing the dates ?Using Smartsheet254C. Srinidhi Ragunathan
-
Alessandro Terranova 46 views 27 comments 0 points Most recent by Alessandro Terranova Formulas and FunctionsFirst post 11/01/19,Last post 01/14/20Hi Community, I am trying to calculate the actual duration starting from a list of Start and End dates. What I am trying to achieve is to exclude duration overlaps in order to get the actual effort days only, but including not contiguous…Formulas and Functions4627Alessandro Terranova
-
Log of user access to sheetsAnsweredAnswered M. David 45 views 6 comments 0 points Most recent by Andrée Starå Premium Apps and IntegrationsFirst post 01/03/20,Last post 01/14/20In the Control Center, I create a group of files each time a new project is started. I am being asked to create a report/sheet/dashboard that shows the date of the last time the project manager viewed/edited the sheet. If successful, this …Premium Apps and Integrations456M. David
-
First post 09/26/19,Last post 01/14/20We're new user trying to understand how we can use daily schedule template to repeat itself on-going basis. When I go to settings it is grayed out so there goes that option. Spreadsheets are not something I've used too much and support is …Using Smartsheet383craig105421
-
First post 12/20/19,Last post 01/14/20Hi, I am trying to create a meeting minutes template which both facilitates taking minutes against an agenda and also automates distribution of minutes to 'Attendees' when ready. I am using multiple rows to list Agenda topics (under a par…Using Smartsheet527Jocelyn Bailey
-
First post 09/16/19,Last post 01/11/20Thought I would start my own thread regarding this since it seems very quiet around this change. Am I the only one having no luck in using the suggested shortcut CTRL ] to indent? I am using Windows 10, Chrome webbrowser and swedish keyb…Using Smartsheet258Mattias
-
First post 11/04/19,Last post 01/11/20I am trying to prove that the automation workflow alert that was set up actually sent out to one of my users. I can go to the View HIstory section of the Control Center intake sheet, but it does not show proof of who received the automati…Using Smartsheet354jennytracy -
Answered C. Srinidhi Ragunathan 35 views 1 comment 0 points Most recent by Alejandra Using SmartsheetFirst post 01/07/20,Last post 01/08/20Greetings. The previous system admin of our Smartsheet account has left the organisation. How do we change the system admin now ? There is a need to add more resources to our account and we are not able to do the same. Kindly provide sug…Using Smartsheet351C. Srinidhi Ragunathan
-
First post 08/21/18,Last post 01/08/20Has anyone received this error message before? What are the options for large data? (Image)Using Smartsheet729David Skinner
