-
Update Columns in Existing Row Using Forms
Hello, I have a sheet where I am tracking construction progress. There are a lot of data/calculations that my field personnel do not need. I want a simple interface for them to update data (% Complete, Actual Date Completed, etc.) Each row is auto-numbered for tracking. Is there a method for a form or process to create…
-
Dependency Logic based on one or the other predecessor tasks
Is is possible to create schedule logic where a dependent task is dependent on one of two predecessors (either or not both)? For Example: I am trying to build out a schedule template for if a permit is required vs not for a specific project. IF a permit is required then the rest of the schedule should be based on the…
-
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.
