Construction

Discussion List

  • Cell Linking from a Form
    In Using Smartsheet
    Hello I am trying to do cell linking from when the information is entered in from a form rather than directly onto the sheet itself.  When I do this it adds the information onto the sheet however it moves the cells I am trying to link down…
    127 5
    127 views 5 comments Most recent by Sharon Isaac Using Smartsheet
  • Linking checkboxes across 2 sheets
    In Formulas and Functions
    I've got 2 spreadsheets for tracking job progress. One is an end of day report filled out by field personnel. The other is a collection of all the information about various jobs gathered from the end of day reports and manually entered dat…
    Answered - Pending Review
    649 10
    Answered - Pending Review 649 views 10 comments Most recent by Paul Newcome Formulas and Functions
  • Report on all sheets I am part of as Assigned To
    In Using Smartsheet
    Many of our team members will be allocated to many different sheets. 1. Is there a feature how to make a report showing all sheets I am assigned to?, and as a continuation a report showing specific tasks in those projects, for example Gat…
    304 5
    304 views 5 comments Most recent by Jose Maria Martinez Using Smartsheet
  • Show ONLY Tasks in a Date Range
    In Formulas and Functions
    Is there any formula and/or filter that will enable me to show only the tasks that are scheduled to happen during a particular 3 week time frame, much like a 3 week lookahead. I want to show tasks that, during the time frame, have the foll…
    Answered - Pending Review
    32 2
    Answered - Pending Review 32 views 2 comments Most recent by Wesley Cross Formulas and Functions
  • Trying to delete a large number of rows trough API
    In API & Developers
    Hi I am using the Node JS SDK to delete the content from a sheet. It works fine but for a lot of rows it fails (I have tested with a minimun of 1000). I get an error that says that the request is to large for the server. I understand what…
    249 5
    249 views 5 comments Most recent by Ian Macintosh API & Developers
  • 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
    1205 22
    Answered - Pending Review 1.2K views 22 comments Most recent by Paul Newcome Formulas and Functions
  • How to create this COUNTIFS with AND/OR/NOT
    In Formulas and Functions
    I cannot figure out how to create this formula to get the metrics. I can get each individual dept metric correct using =IFERROR(COUNTIFS({(Phoenix) Project Tracker - Aerial Status}, AND(@cell <> "No", @cell <> "…
    Answered - Pending Review
    21 2
    Answered - Pending Review 21 views 2 comments Most recent by Kelly Moore Formulas and Functions
  • One off Saturdays in Gantt
    In Using Smartsheet
    Hi all, I work in construction and use the gantt chart heavily to manage scheduling subs. I have a unique situation for my project where I may have to schedule work on a Saturday. Is there any way to allow a single Saturday, instead of o…
    Answered - Pending Review
    11 4
    Answered - Pending Review 11 views 4 comments Most recent by Austin Clos Using Smartsheet