Construction

Discussion List

  • 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
    232 13
    Answered - Pending Review 232 views 13 comments Most recent by JamieLim Formulas and Functions
  • Smartsheet - Procore & Cyberco Sync
    In Premium Apps and Integrations
    We just started creating schedules in Smartsheet and are trying to sync them to Procore via Cyberco and running into issues. Cyberco's site is vague with little in ways support material. Would love to hear some experiences / input on this …
    Answered - Pending Review
    16 1
    Answered - Pending Review 16 views 1 comment Most recent by Chris Mondeau Premium Apps and Integrations
  • Automatic Children Indenting
    In Using Smartsheet
    Hello,   Is it possible to set up a formula for information (if it is the exact same as the parent/child row above) that you have underneath a child/parent row to automatically attach itself inside the Parent/Child Hierarchy? I would rat…
    671 15
    671 views 15 comments Most recent by Andrée Starå Using Smartsheet
  • QR Coding Tied to Forms
    In Using Smartsheet
    Hello, I'm looking to develop a process for maintaining our mechanical equipment. Ideally a Technician could scan a QR code that would link them to a list of form links. (Each piece of equipment requires 3-5 types of maintenance, requirin…
    Answered - Pending Review
    13 1
    Answered - Pending Review 13 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Convert text date, to date 2018-04-18
    In Formulas and Functions
    I have a primary field that contains date information and I need to convert it to a date, so that I can compare it against another date field.     The format of the text date is 2018-04-18, and I need to convert it to a date, and cannot …
    664 3
    664 views 3 comments Most recent by jg124 Formulas and Functions
  • 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…
    4045 26
    4K views 26 comments Most recent by Paul Newcome Formulas and Functions
  • # of Tasks Assigned to Each Person from a Folder
    In Using Smartsheet
    Hi All, Working on trying to find a solution to the following. We have a dashboard we'd like to use to understand the workload across all of our standard projects. Specifically, we want to know the number of tasks assigned to each person …
    Answered - Pending Review
    33 5
    Answered - Pending Review 33 views 5 comments Most recent by Andrée Starå Using Smartsheet
  • Dropdowns in a dashboard, is it possible?
    In Using Smartsheet
    I have one sheet that has metrics for a few of my employees, I was hoping there was a way to get the drop down menu function for each employee transferred onto a Dashboard highlighting everyone's metrics. *The drop downs show their total …
    780 11
    780 views 11 comments Most recent by Andres Londono Using Smartsheet