I have a Task B that cannot start before Task A was finished and that should finish the same time as Task C.
When I enter 2 predecessors for B, namely that Task A has FS and Task C has FF, the smartsheet always takes into account o…
Using Smartsheet16Tibor Staub
Our program consists of 5 sub projects and each of them have their plan. All of these individual plans need to be rolled up into a consolidated master plan that would finally track the inter-dependencies and the critical path.
Hi, Community! I am wondering if anyone else is using SmartSheet for an institutional planning calendar. I chose a template of project with gantt. Most of the tasks on the calendar, however, are annual, bi-annual, semi-annual, etc. I am tr…
Using Smartsheet40Mary Vogt
I apologize for the length of my post, but I want to be thorough in describing what I would like to do and what I’ve already tried. I’ve also searched through help and the forums, and I either haven’t found a solution or am too hyperfocuse…
Using Smartsheet44Rob Ford
Hello, I have a sheet where I can see budget, actual and variance for my project budget. So column 1 is january budget, column 2 january actual and column 3 january variance, and so on.
All I want to is to create a line-type chart for my d…
Using Smartsheet13Laura Corredor
I have several 13 Smartsheets that make up a campaign of projects. At the top of each sheet I have some metrics, including the % complete for all the projects, combined, on the Smartsheet.
I want to create a new Smartsheet that links dat…
Formulas and Functions8Donna T
Hi SmartSheet community!
This may be an odd one to describe but I am going to try my best. I have a process that is a bit circular and is also a "maybe situation." For our product, we will go through rounds of optimization but o…
Using Smartsheet25Zoe Charalambous
I have created dashboards that include charts, for which I have selected specific colors for each category. Data for the charts come from different sheets. However, everytime I add a new row to the source sheet, I have to update manually t…
I have a Gantt of a project which has weekly minutes compiled of site meetings and others. How do I create a specific report that goes to the project manager and asks him to load specific copy onto smartsheet?
Using Smartsheet20Ben Smith
I'm trying to see if formulas can reference reports or just root SS. I ran a report for all late tasks assigned to all people in a department. I then wanted to use a COUNTIF formula that would sum up all the late tasks of a certain person.…
Formulas and Functions274UnaB
Hi. i have built some reports off a large sheet where i have chosen to show only select columns related to the function of the report. I have also hidden some columns within the report. Yet when i use the Edit, Print, or Send dialogue boxe…
I am trying to build a nested at risk formula based on the following triggers.
-End date is today and Status is not complete it will trigger
-There is not enough time between today and the end date for the duration period left. So, if dura…
Using Smartsheet21Kayla Johnstone
I am attempting to consolidate multiple business worksheets, for an aggregate pie chart health status on a dashboard for executive management. See word doc for details
I have a main grid with several columns and a webform that feeds into that grid. This tracker is used by my team to track several job "types" defined in one of the destination grid columns as "Large Project", Medium Pro…
Using Smartsheet18Nikki Hopper
Can someone provide some insight to creating a testing log? Either point me to an existing Smartsheet template set that can be massaged to fit my testing needs or have a test log template set that you are willing to share.
Using Smartsheet23Stanley Paul
I 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 Smartsheet395Michele Deo
We started a new process for course development that has tracking development of each of our courses in separate sheets. 1 course per sheet. Its easy to pull a report of how many of those courses are now in a complete status but I am tryin…
Formulas and Functions16Mike Wilday
I would like to send a notification with an attachment based of a status change. The notification works, but doesn't include the attachment. I have seen on the community that this is not possible in SS - is this still true?
API & Developers153katherinehall
I have a sheet that is best in card view. Is there a way to set this as a default view for all users of the sheet or does everyone have to set it themselves?
Using Smartsheet119Angie Hatfield
I am trying to create an aggregated view of data from multiple sheets using the "Sheet Summary Report" but when get to the Builder, it only shows the system columns for display. Obviously this is not helpful if I cannot merge tog…
I'm trying to find out if I can color code only the name bubble.
For example, below I'm using the multiple-drop down column formatting and all names are shown in grey. It would be nice to show Whitney in purple, and Laura in yellow, so th…
Formulas and Functions13Jena Heath
I have 16 grids that all use a Contact List with 23 of the same client contacts. (1) its a HUGE waste of time to have to populate 23 contacts into a list 16 times and (2) every time a new person joins or leaves the team, I have to go into…
Using Smartsheet68Cheryl Crouse
I am using this simple formula in a new field in Sheet Summary & I keep getting an "Unparseable" Error.
=COUNTIF(RESPONSIBLE ENTITY:RESPONSIBLE ENTITY, "FIRM")
Formulas and Functions38Donni Matthew
I'm trying to count the tasks in my gannt per each week in a separate grid. Then i'll make a graph representing work overloads throughout the year.
Here is my formula that calculate 0 every time (at least not an error) :
Formulas and Functions22Assaf Elad
We have been using Smartsheet for some time and love this tool (changed from MS Project). However, the PDF export is not adequate for the rest of the tool.
It seems that Smartsheet can only export/print PDFs as images, …
I have a start date of 10-1-19 and a stop date of 10-31-19 and I want to see how many working days are in the range. I am using the formula as follows:
=NETWORKDAYS([Schedule start]1, [Schedule stop]1,)
I keep getting #UNPARSEABLE
OK sleuths, this one is for you. We are an organization that loves powerpoint, and no matter what dashboards we create, a powerpoint presentation is typically still needed. We need a way to consolidate our project status in one easy docum…
Premium Apps and Integrations190Tana Perkins
I have a risk register for a project that has well over 100 risks documented and I have them categorized into 17 different risks. I would like to be able to create a formula to count how many risks exist under each category and then a…
Formulas and Functions25Jorjie Higginson
We are currently managing a construction project with smartsheet and have created a Gantt Diagram and a few Dashboard to monitor several KPIs.
The dashboards are updated automatically with every changes in the master project and pro…
Has there been any progress with adding card view to reports? Has this been an approved feature and scheduled for a release? Our company has been pushing a move to JIRA because of the gap with smartsheet in allowing our teams to vi…
Using Smartsheet355Jess Evers