Construction
Discussion List
-
Sorting & Filtering Linked Cells From Source SheetIn Using SmartsheetI am unable to figure out how to sort and filter linked cells from the source sheet. I have a sheet with cell links which needs to be sorted or filtered when the source sheet is sorted or filtered. I am unable to use a report or dashboard…
-
Filter to show only dates from this week???In Formulas and FunctionsI'm making a project schedule for our construction company. I would like to be able to have a filter that only shows "Start Date" that is equal to this week or this month. Is that possible?
-
Automatic Predecessor AdjustmentIn Formulas and FunctionsHey All! I have a question about how to have predecessors or just tasks in a schedule to automatically update when they are moved in the schedule. I am trying to create a production schedule for our Sheet Metal shop and it is created with…
-
How can I enter and display construction measurements?In Formulas and FunctionsI'm creating a report for field workers to measure site conditions. They use their tablets to enter the measurements into the report which updates the Smartsheet for the job. We use standard construction measurements. Is there any way to d…
-
#INVALID VALUE error with collect/index/match/small functionIn Formulas and FunctionsHi all, Feeling like I've got a real head scratcher here- I have been struggling with this formula creation for the past few days and am hoping that the gurus can help! Within my sheet, I have UniquePart pulling in a list of unique values …Answered - Pending Review 40 views 1 comment 0 points Most recent by Genevieve P. Formulas and Functions
-
Function vs Project StructureIn Using SmartsheetI am a contractor with many projects and I am trying to determine if it is most beneficial to have the individual projects have their own sheet with various silos of activities (in-field construction activities, office deliverables, accoun…
-
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…
-
Pre-populate a formIn Using SmartsheetI am building a change control log. Is it possible to pre-populate a form with cell data from a sheet? For example, project name, ID, customer, description and resource from the sheet to help the process of logging a change to the change c…Answered - Pending Review 6.4K views 62 comments 1 point Most recent by Steve Gebbie Using Smartsheet
-
Is there a formula or function that allows text to be removed and replaced elsewhere on the Sheet?In Formulas and FunctionsHard to explain just in the question box. We have a staffing schedule for our company which allows us to see who is currently on jobs and who is coming up for availability for an upcoming job. We are trying to figure out if there is a type…Answered - Pending Review 18 views 3 comments 0 points Most recent by Paul Newcome Formulas and Functions
