Construction
Discussion List
-
Index Match or Index Collect with multiple criteriaIn Formulas and FunctionsI'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 views 13 comments 0 points Most recent by JamieLim Formulas and Functions
-
Smartsheet - Procore & Cyberco SyncIn Premium Apps and IntegrationsWe 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 views 1 comment 0 points Most recent by Chris Mondeau Premium Apps and Integrations
-
Automatic Children IndentingIn Using SmartsheetHello, 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…
-
QR Coding Tied to FormsIn Using SmartsheetHello, 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…
-
Convert text date, to date 2018-04-18In Formulas and FunctionsI 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 …
-
COUNTIFS/CONTAINS FUNCTIONIn Formulas and FunctionsHi 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…
-
# of Tasks Assigned to Each Person from a FolderIn Using SmartsheetHi 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 …
-
Dropdowns in a dashboard, is it possible?In Using SmartsheetI 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 …