-
How to create a master schedule sheet in project prog schedule mode by linking other schedule sheets
Hello, first of all sorry for my English, I'm doing a translation from French. I work in the construction industry and we have big construction projects. Each major construction project includes several complex tasks. Each of these tasks is a project in itself and it has its own schedule. The goal is to bring together all…
-
Checklists
If you run your schedule out of Smartsheet, how do you hand attaching checklists to certain tasks? For instance, we might want to add a Q/A checklist to a flooring installation task to check for items like finish, correct item installed, clean/well-done, etc. I would rather not add additional rows to the sheet to…
-
Formula for a checkbox column
I have searched all the forums for the formula for the checkbox sum & none of them have worked for me. I need to total the sum of the checkboxes that are checked within a column.
-
Best practices/overbooking for Smartsheet calendar app?
My company (Bath remodeling company) has our install calendar currently on excel and we do about 22 jobs a day. We are planning to migrate our calendar to Smartsheet calendar app and we are having issues finding a way to provide block outs for some Installers when they request off or how to prevent overbooking. I created a…
-
Invoice & Budget Tracking for Construction Projects - using Attachments
This is an easy way to keep track of your invoices
-
Error when opening a sheet
As I finished working on a sheet last night I got an error message saying to log off and back on. I logged off for the night and now we’re getting the same error message when trying to open the sheet. When we use the search feature it doesn’t appear. When we go to the folder it’s there, but we get the error message when…
-
Index Match Showing Incorrect Amounts - Formula when there is no information to pull
Hello! I am stuck on the INDEX MATCH pulling incorrect amounts when I reference another sheet. It will work for some cells, but not others. I am thinking since the parent sheet doesn't have all the line item costs for each store such as "Shelving" or "IT/LP", that could be the issue, but not all stores will have those…
-
Manpower Summation from Schedule
Hi! I have a construction schedule with the following column names: task, start date, end date, duration, assigned to, manpower. The "assigned to" column is different subcontractors such as "sheet metal subcontractor", "piping subcontractor" etc. My schedule is about 1500 lines long with lots of concurrent activities. My…
-
Cell Linking from a Form
Hello I am trying to do cell linking from when the information is entered in from a form rather than directly onto the sheet itself. When I do this it adds the information onto the sheet however it moves the cells I am trying to link down to the next row and will not transfer over the information. Is there a way I can do…
-
Report on all sheets I am part of as Assigned To
Many of our team members will be allocated to many different sheets. 1. Is there a feature how to make a report showing all sheets I am assigned to?, and as a continuation a report showing specific tasks in those projects, for example Gate Review, or Offer Submission? Those tasks are not necessarily assigned to that…