Construction
Discussion List
-
Dependency Logic based on one or the other predecessor tasksIn Formulas and FunctionsIs 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 projec…Answered - Pending Review 15 views 1 comment 1 point Most recent by Genevieve P. Formulas and Functions
-
Rows will not stay in place. NEED HELP NOWIn Using SmartsheetWe 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 pri…
-
Returning the most recent value that matches multiple criteria (cross-sheet lookup)In Formulas and FunctionsHi 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 Serv…Answered - Pending Review 32 views 2 comments 0 points Most recent by Robert Bennett Formulas and Functions
-
RTF in Dashboard WidgetIn Using SmartsheetI downloaded an example dashboard which tracked multiple projects. Looked good and decided to build my dashboard to match example. Example dashboard has a Rich Text Widget which has multiple formats within. However when I try to use the…
-
Howto Save a Filter with a Column of data that is SummarizedIn Using SmartsheetI 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 - statu…
-
Announcement
Do you use custom branding for your Smartsheet account or Workspaces? We’d love to get your feedbackIn Using SmartsheetHi 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 a… -
COUNTIFS/CONTAINS FUNCTIONIn Formulas and FunctionsHi All, I need help with a formula to Count every instance a name appears in a multi-select row of a column based on criteria from another column first. At present this is my first formula: =COUNTIFS({CORP ADMIN TEAM TASKS Range 1}, &qu…
-
Quickbooks & SmartsheetIn API & DevelopersSo. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use. It has many application & the proof of concept exists and we use it. We use it for an approval process (for in…
-
How to create a master schedule sheet in project prog schedule mode by linking other schedule sheetsIn Using SmartsheetHello, 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 i…
