-
Project Schedule/Milestone Tracking Solutions
Hi Everyone! Does anyone have a project schedule/milestone tracking solution to share? I'm trying to create a company wide solution to input/track schedules for multiple projects, multiple milestones within each project, and provide executive level visibility of the status of each project. Any good ideas would be…
-
All Dates populate based off one date
Hello, I am trying to create a sheet where I can put in one date in the Target Start Date column then all other dates populate from that date based off the duration it takes to do all the task. Is this possible?
-
Is it best to link only one predecessor to each task or is it ok to have multiple?
I am working on a construction schedule and wondering what the best practice is for attaching predecessors. I have noticed my Gantt chart is currently a bit all over the place and I am thinking it is because I have too many predecessors for each task. Do more experienced Smartsheet users recommend only having one…
-
Excited to Implement Work Apps
I’ve learned a lot at the conference, but I’m most excited to implement Work Apps with the teams I work with. A one stop shop of all the necessary information will help improve their efficiency.
-
Very ENGAGING at #Engage2022
Having so much fun and learning all the things at Engage 2022 in Seattle!
-
Help Searching Mutiple Job#
I want to be able to insert in my table the information: PO,Project Description,Customer,Payment Teams,Business Unit,Submitter,Notes from anothe sheet that contains the Job information. From the Job# column, I've done it before with an index match but only when is one project. I want to be able to do it for multiple Job…
-
Total Site % Complete + health
I need the total site % Complete Each milestone has % complete for the site project What is the sample formula to calculate each milestone % complete columns to give the site Total % complete? Let’s say, Milestone ABCDEF etc I just want to SUM all the milestone % complete to give me the total project % complete Then the…
-
TOTAL% COLUMN
-
Linking checkboxes across 2 sheets
I've got 2 spreadsheets for tracking job progress. One is an end of day report filled out by field personnel. The other is a collection of all the information about various jobs gathered from the end of day reports and manually entered data. I want to link a checkbox when any end of day report has a "Install complete"…
-
Indenting Text for Dashboard Exports
Hey Smartsheet Community! I am posting this in response to the Engage Product Vision sessions that Ben Canning hosted, where there was some talk about someday exporting dashboard content other mediums such as PDF, Powerpoint, Google Slides, etc. In my company's change management journey we have been working hard to…