-
formulating dates excluding weekends
I 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 cannot have. Is there a way to correct this issue without enabling dependencies and…
-
Construction Contract Work Flow/Best Practices
I work for a construction firm and would like some guidance in the first steps to creating a "contract health" dashboard. I am managing all contract packages and the documents that supplement them for all of the projects within the company i work for and would like to find consistency and a more "automated" checks and…
-
Budget Management
All I wanted to show you how I am using smartsheet to keep my budget reporting in real-time. I have 3 sheets 1) A Budget sheet 2) An Invoice Sheet 3) A Project Action Log The purposes are as follows Budget sheet This houses my line my approved budget using MasterFormat and also my Non-construction costs like Architect…
-
Calculating cumulative values and reducing the total sum each day
Hi, 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 reduces by (1) for each day that passes without incident. I have (1) sheet that acts…
-
Report with image of attachments
Hi Everyone, Is there a way to create a report that shows the image of the attachments? We have a quality control sheet that new items get added through a form along with a picture. I would like to create a report that can show the picture next to the fields associated the punch list item. Another way would be to export…
-
Formula under Duration in a Gant chart
Hi 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 resources to set the best outline. I would like to set the work (total effort to…
-
Way to have multiple people claim an item
Hello. 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 multiple people be able to claim an item if there is Available Quantity left, as well as put…
-
Filter to show only dates from this week???
I'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!
So 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 response option and region. So far this formula works great! =COUNTIFS([Delivery…
-
IF condition is true, copy a value into another column
I have a sheet where multiple people have to approve an item before it is 'approved'. I am needing to copy a cell from the Cost column into the pending, approved, or rejected column based on the current status. So if the P/R/A column equals "P" I need the $ in the cost column to populate in the Pending Cost Column, etc.…
