Construction
Discussion List
-
Manpower Summation from ScheduleIn Formulas and FunctionsHi! 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 views 2 comments 0 points Most recent by Jake Anderson Formulas and Functions
-
Charts Plotting 0In Using SmartsheetI 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…
-
Cell Linking from a FormIn Using SmartsheetHello 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…
-
Report on all sheets I am part of as Assigned ToIn Using SmartsheetMany 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…
-
Show ONLY Tasks in a Date RangeIn Formulas and FunctionsIs 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 views 2 comments 0 points Most recent by Wesley Cross Formulas and Functions
-
Trying to delete a large number of rows trough APIIn API & DevelopersHi 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…
-
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 2.2K views 22 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
How to create this COUNTIFS with AND/OR/NOTIn Formulas and FunctionsI 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 views 2 comments 0 points Most recent by Kelly Moore Formulas and Functions