Discussion List

  • Manpower Summation from Schedule
    In Formulas and Functions
    Hi! I have a construction schedule with the following column names: task, start date, end date, duration, assigned to, manpower. The "assigned to" column is different subcontractors such as "sheet metal subcontractor", …
    Answered - Pending Review
    95 2
    Answered - Pending Review 95 views 2 comments Most recent by Jake Anderson Formulas and Functions
  • Charts Plotting 0
    In Using Smartsheet
    I recently contacted support to find out if there was an option within dashboard charts to keep the charts from plotting 0. I received the following response: Currently we don't have a feature in place that will prevent specific values fr…
    941 14
    941 views 14 comments Most recent by Paul Newcome Using Smartsheet
  • 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…
    184 5
    184 views 5 comments Most recent by Sharon Isaac Using Smartsheet
  • 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…
    374 5
    374 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
    102 2
    Answered - Pending Review 102 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…
    365 5
    365 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
    2151 22
    Answered - Pending Review 2.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
    26 2
    Answered - Pending Review 26 views 2 comments Most recent by Kelly Moore Formulas and Functions