- Linking checkboxes across 2 sheets
I'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 data. I want to link a checkbox when any end of day report has a "Install complete"…
- Automatic Children Indenting
Hello, Is it possible to set up a formula for information (if it is the exact same as the parent/child row above) that you have underneath a child/parent row to automatically attach itself inside the Parent/Child Hierarchy? I would rather not have to manually go in and Indent new info from information dumps, as there will…
- Can you group columns?
I have a very large Smartsheet that contains contact info, partners, dates for various deliverables, financials, etc. I'm wondering if there is a way to group columns that reference similar tasks thereby make moving around the sheet a little more efficient? For example there are 14 columns that pertain to permitting, 5…
- Construction Bid Comparison Solution
Does anyone out there have a tried and true construction bid comparison solution they'd be willing to share? Looking to make automation from Bid Tracking/Comparison/Scope Coverage to Contracting and having trouble going from our current solution which is column based, to a smartsheet format which is row based. screenshot…
- Conditional Formatting not applying consistently
I have a sheet with conditional formatting rules so that if there is a "0" in a cell the text will be gray and if there is a negative number it will be red. If I close the sheet and then open it again the conditional formatting does not show, but if I go into the setting and basically pretend to change the formatting it…
- Notification When a Date Changes
我试图使用公式和notifications so that if a person does not change a date in a cell, then they are sent an email reminder. Once they change the date in the cell, they won't be sent the reminder. In the picture above, somebody will manually enter the Due Diligence Date. The Site Development and Hard…
- 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…
- 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…
