-
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…
-
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…
-
Virtual User Group Recording - March 24
If you missed our March 24 Construction Virtual User Group, no worries - we recorded it for you! Here is the agenda we covered: Customer Spotlight: Hear how fellow Smartsheet user Mike Vaughn, Project Coordinator at Edmonds Engineering, utilizes Smartsheet for project management and how he created a fee estimator project…
-
Trying to delete a large number of rows trough API
Hi I am using the Node JS SDK to delete the content from a sheet. It works fine but for a lot of rows it fails (I have tested with a minimun of 1000). I get an error that says that the request is to large for the server. I understand whats happening, but I was wondering if there is another way to clear a sheet using the…
-
How to create this COUNTIFS with AND/OR/NOT
I cannot figure out how to create this formula to get the metrics. I can get each individual dept metric correct using =IFERROR(COUNTIFS({(Phoenix) Project Tracker - Aerial Status}, AND(@cell <> "No", @cell <> "Complete"), {(Phoenix) Project Tracker - Status column}, AND(@cell = "Complete"), {(Phoenix) Project Tracker -…