Construction

 

Discussion List

  • Sorting & Filtering Linked Cells From Source Sheet
    In Using Smartsheet
    I am unable to figure out how to sort and filter linked cells from the source sheet. I have a sheet with cell links which needs to be sorted or filtered when the source sheet is sorted or filtered. I am unable to use a report or dashboard…
    296 7
    296 views 7 comments Most recent by Andrée Starå Using Smartsheet
  • Filter to show only dates from this week???
    In Formulas and Functions
    I'm making a project schedule for our construction company. I would like to be able to have a filter that only shows "Start Date" that is equal to this week or this month. Is that possible?
    1236 19
    1.2K views 19 comments Most recent by Jaye Casciano Formulas and Functions
  • Automatic Predecessor Adjustment
    In Formulas and Functions
    Hey All! I have a question about how to have predecessors or just tasks in a schedule to automatically update when they are moved in the schedule. I am trying to create a production schedule for our Sheet Metal shop and it is created with…
    325 7
    325 views 7 comments Most recent by Lllllloyd Formulas and Functions
  • How can I enter and display construction measurements?
    In Formulas and Functions
    I'm creating a report for field workers to measure site conditions. They use their tablets to enter the measurements into the report which updates the Smartsheet for the job. We use standard construction measurements. Is there any way to d…
    Accepted
    30 4
    Accepted Answer 30 views 4 comments Most recent by Paul Newcome Formulas and Functions
  • #INVALID VALUE error with collect/index/match/small function
    In Formulas and Functions
    Hi all, Feeling like I've got a real head scratcher here- I have been struggling with this formula creation for the past few days and am hoping that the gurus can help! Within my sheet, I have UniquePart pulling in a list of unique values …
    Answered - Pending Review
    40 1
    Answered - Pending Review 40 views 1 comment Most recent by Genevieve P. Formulas and Functions
  • Function vs Project Structure
    In Using Smartsheet
    I am a contractor with many projects and I am trying to determine if it is most beneficial to have the individual projects have their own sheet with various silos of activities (in-field construction activities, office deliverables, accoun…
    Answered - Pending Review
    9 1
    Answered - Pending Review 9 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • COUNTIFS/CONTAINS FUNCTION
    In Formulas and Functions
    Hi 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…
    8828 43
    8.8K views 43 comments Most recent by Paul Newcome Formulas and Functions
  • Pre-populate a form
    In Using Smartsheet
    I am building a change control log. Is it possible to pre-populate a form with cell data from a sheet? For example, project name, ID, customer, description and resource from the sheet to help the process of logging a change to the change c…
    Answered - Pending Review
    6448 62
    Answered - Pending Review 6.4K views 62 comments Most recent by Steve Gebbie Using Smartsheet
  • Is there a formula or function that allows text to be removed and replaced elsewhere on the Sheet?
    In Formulas and Functions
    Hard to explain just in the question box. We have a staffing schedule for our company which allows us to see who is currently on jobs and who is coming up for availability for an upcoming job. We are trying to figure out if there is a type…
    Answered - Pending Review
    18 3
    Answered - Pending Review 18 views 3 comments Most recent by Paul Newcome Formulas and Functions