Construction

Discussion List

  • Creating a Report that ONLY shows rows with Attachments
    In Using Smartsheet
    Is there a way to filter out rows that show up in my report that do not have attachments? I'm building a report that shows my subcontractors any row that's had an attachment added to it in the last 7 days, but I can't seem to find a way…
    Answered - Pending Review
    160 5
    Answered - Pending Review 160 views 5 comments Most recent by Genevieve P Using Smartsheet
  • Child Rows Automatically Move to Parent Rows Based on Column Cell Value
    In Using Smartsheet
    How do I get child rows to move to specific parent rows based on data from a specific column? I have active, lead, not bidding, and submitted statuses. When a bid is submitted I would like that row to move to the submitted parent. If it is…
    252 4
    252 views 4 comments Most recent by Christina Lam Using Smartsheet
  • Update Confirmation email limitations
    In Using Smartsheet
    Has anyone figured out a way to disable the update confirmation email that is sent following an update request? The email is confusing my user community because it links to a sheet they don't have access to. Is it possible to even change t…
    230 2
    230 views 2 comments Most recent by Caroline S. Using Smartsheet
  • How do i track progress based on output?
    In Formulas and Functions
    I have a project that involves building fences in a number of locations. Each location has a budgeted lineal distance of fencing, and we will need to track progress of distance completed against budgeted. I can do it in an excel spreadshee…
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Sam Harwart Formulas and Functions
  • Index Match or Index Collect with multiple criteria
    In Formulas and Functions
    I'd like to return a Contact to a cell if two criteria are met. I've tried using the index collect formula copied below but I continue to receive #INCORRECT ARGUMENT SET. =INDEX(COLLECT({Vendor Contact}, {Project Name}, [Project Name]@row,…
    Answered - Pending Review
    41 10
    Answered - Pending Review 41 views 10 comments Most recent by Shelby Formulas and Functions
  • Countifs - 2 field ranges plus a date
    In Formulas and Functions
    Hi, I am trying to create a formula to count companies (1st column) that we won a project(2nd shows win/lose) in certain date ranges (example Q1 - January to April of 2020) I can get the count formula right that counts companies that we w…
    Answered - Pending Review
    17 1
    Answered - Pending Review 17 views 1 comment Most recent by David Tutwiler Formulas and Functions
  • Stuck Sheet
    In Using Smartsheet
    We have a sheet which is locking up every time you open it. If we have it open, you cannot click on any other sheet or the home icon to get to another sheet or workspace. We have found that we can right-click another sheet and open in a …
    Answered - Pending Review
    12 7
    Answered - Pending Review 12 views 7 comments Most recent by Andrée Starå Using Smartsheet