-
Rows will not stay in place. NEED HELP NOW
We use a sheet as both a schedule and data collection tool as part of a much larger system we just put in place (literally 5 days ago, moved from google sheets). The information is organized manually first by employee and second by the priority of projects. Recently, the information in the sheet began jumping randomly…
-
Returning the most recent value that matches multiple criteria (cross-sheet lookup)
Hi All, I am trying to create a preventative maintenance schedule for our fleet vehicles and heavy equipment machines based on the vehicle/machine, the most recent odometer readings or machine hours, and the type of service needed (PM Service 2, PM Service 3, Oil Change, etc.). For my source sheet, I'm using a repair and…
-
Howto Save a Filter with a Column of data that is Summarized
I use Smartsheet to track construction jobs in columns listed by Type of Job, Year, Contract Amount and other characteristics. Filters have been created to display jobs by - specific type of work involved - year of bid submitted - status of bid I am able to summarize the filtered column for the Contract Amount but am…
-
Do you use custom branding for your Smartsheet account or Workspaces? We’d love to get your feedback
Hi there! Does your team get excited about custom branding? Our team of UX researchers would love to chat with you. We are looking for people to join a 20 minute feedback session on some updates we’re making to how custom logo and colors appear. Here are the details: People who complete an appointment will get a $50…
-
Conditional Drop-down list columns
Hey Is it possible to have the the drop-down list of a column changed based on the value of another column? Eg. If column A's value is set to "Work stage 2" column B's drop-down list will have a specific list, but when it is set to "Work stage 2" column B's drop-down list changes automatically to a different list. Say…
-
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
