Construction
Discussion List
-
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…
-
Linking checkboxes across 2 sheetsIn Formulas and FunctionsI'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 views 10 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
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 32 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 1.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 21 views 2 comments 0 points Most recent by Kelly Moore Formulas and Functions
-
One off Saturdays in GanttIn Using SmartsheetHi 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…
