Construction

Discussion List

  • Volunteer Allocation
    In Formulas and Functions
    Hi All,  I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
    131 3
    131 views 3 comments Most recent by Brianne Laird Formulas and Functions
  • Find all similar entry names and add their qty
    In Formulas and Functions
    Hello I have a sheet I made where I load in all my orders of items needed for a job. Each Item has a code assigned to it I'm calling the Entry Name. There will be times where the same Code/Entry Name will appear several times during the li…
    Accepted
    23 8
    Accepted Answer 23 views 8 comments Most recent by Andrée Starå Formulas and Functions
  • Form Confirmation Options
    In Formulas and Functions
    I have created a purchase order sheet and form which auto generates a number each time. How do I reference this number to pull it through into the form completion confirmation message and/or email?
    1230 4
    1.2K views 4 comments Most recent by Debbie Sawyer Formulas and Functions
  • Budget v. Invoice Cost Codes
    In Formulas and Functions
    I have two Smartsheets. Sheet 1 is my budget broken down into various cost codes. Sheet 2 is a log of all my invoices with cost codes and amounts assigned to each invoice. I am trying to take the amount from each invoice and have them popu…
    Accepted
    15 11
    Accepted Answer 15 views 11 comments Most recent by Paul Newcome Formulas and Functions
  • Trouble with COLLECT in INDEX/MATCH
    In Formulas and Functions
    I'm trying to troubleshoot an INDEX/MATCH formula that contains a COLLECT statement which is supposed to limit what cells are being used for the MATCH. I am referencing a project schedule, looking for the "next deliverable" - we…
    537 5
    537 views 5 comments Most recent by Paul Newcome Formulas and Functions
  • Calculating costs for a task over more than one month
    In Formulas and Functions
    I'm trying to come up with a formula to calculate the labor costs per month in one sheet ( 12 columns, one for each month), by referencing another sheet, and referring to the start/finish columns of said task. E.g. Task 1: Start = Aug 27, …
    Answered - Pending Review
    185 2
    Answered - Pending Review 185 views 2 comments Most recent by Paul Newcome Formulas and Functions
  • Using IFS statement with date and check box
    In Formulas and Functions
    The simple statement is I want to have a sum of work hours in a department, that is still incomplete, during a calendar period. Currently the formula is: =SUMIFS([Work Hours]:[Work Hours], Department:Department, "Wire", Finish:Fi…
    Accepted
    48 2
    Accepted Answer 48 views 2 comments Most recent by Paul Newcome Formulas and Functions
  • Duration to a specific task from project start / counting the number of project days
    In Formulas and Functions
    Hello, I'm wondering if there is a function in Smartsheet by which I can create a column that displays the total number of project days from the beginning of the project ("Project Day 1") up to the beginning of each task. For ex…
    Accepted
    105 3
    Accepted Answer 105 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Formula under Duration in a Gant chart
    In Formulas and Functions
    Hi there, I'm new to smartsheet I want to switch from MS Project to smartsheet to set up the planning schedule. I know we can assign multiple of people to a task but at the planning/biding level, I just want to juggle with the number of re…
    239 2
    239 views 2 comments Most recent by Caitlin Smith Formulas and Functions
  • Tracking % Changes Over Time
    In Using Smartsheet
    I have a master sheet (linked to many other, scope-specific QC sheets) that calculates % completion per task. Each row is for a different task, and each task has their own amount of steps. This information is all linked & calculated f…
    261 5
    261 views 5 comments Most recent by Andrée Starå Using Smartsheet