Construction
Discussion List
-
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 …
-
formulating dates excluding weekendsIn Formulas and FunctionsI have 3 columns with different dates. My goal is to enter 1 date, and have the other 2 dates formulated based off the 1st date. I created a formula to satisfy this need, but I am ending up with some dates falling on weekends, which I cann…
-
Formula under Duration in a Gant chartIn Formulas and FunctionsHi there, I'm new to smartsheet I want to switch from MS Project to smartsheet to set up the planning schedule. I know we can assign multiple of people to a task but at the planning/biding level, I just want to juggle with the number of re…
-
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…
-
Way to have multiple people claim an itemIn Formulas and FunctionsHello. I have a sheet that shows available material that our workers can "claim". I have a formula that populates the Available Quantity after a number is entered into the Quantity Claimed column. I am looking for a way to have m…Answered - Pending Review 31 views 1 comment 0 points Most recent by Kevin Smith Formulas and Functions
-
Calculating cumulative values and reducing the total sum each dayIn Formulas and FunctionsHi, I have a Safety Violation Sheet that uses Form Entry to record violations and assign a measured Probation Period in days. If there are multiple entries for an individual, the probation days should accumulate, at the same time the value…Answered - Pending Review 366 views 9 comments 0 points Most recent by Paul H Formulas and Functions
-
Formula for Hours Scheduled by MonthIn Formulas and FunctionsWe're trying to determine how many hours we have scheduled in a month for a particular project based on the start and end date of the project. I can't quite figure out how to set the MAX/MIN without the EOM function. Can someone please hel…Answered - Pending Review 41 views 12 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Quickbooks & SmartsheetIn API & DevelopersSo. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use. It has many application & the proof of concept exists and we use it. We use it for an approval process (for in…
-
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?
-
Multiple nesting help!In Formulas and FunctionsSo I have 6 survey questions with response options of "below expectations, meets expectations, and exceeds expectations." I need it to tell me how many below expectations for question 1 are in each region and so forth for each re…Answered - Pending Review 26 views 3 comments 0 points Most recent by Jon Mark H Formulas and Functions