Construction
Discussion List
-
Creating a Report that ONLY shows rows with AttachmentsIn Using SmartsheetIs there a way to filter out rows that show up in my report that do not have attachments? I'm building a report that shows my subcontractors any row that's had an attachment added to it in the last 7 days, but I can't seem to find a way…
-
Child Rows Automatically Move to Parent Rows Based on Column Cell ValueIn Using SmartsheetHow do I get child rows to move to specific parent rows based on data from a specific column? I have active, lead, not bidding, and submitted statuses. When a bid is submitted I would like that row to move to the submitted parent. If it is…
-
Update Confirmation email limitationsIn Using SmartsheetHas anyone figured out a way to disable the update confirmation email that is sent following an update request? The email is confusing my user community because it links to a sheet they don't have access to. Is it possible to even change t…
-
How do i track progress based on output?In Formulas and FunctionsI have a project that involves building fences in a number of locations. Each location has a budgeted lineal distance of fencing, and we will need to track progress of distance completed against budgeted. I can do it in an excel spreadshee…Answered - Pending Review 12 views 1 comment 0 points Most recent by Sam Harwart Formulas and Functions
-
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 41 views 10 comments 0 points Most recent by Shelby Formulas and Functions
-
Countifs - 2 field ranges plus a dateIn Formulas and FunctionsHi, I am trying to create a formula to count companies (1st column) that we won a project(2nd shows win/lose) in certain date ranges (example Q1 - January to April of 2020) I can get the count formula right that counts companies that we w…Answered - Pending Review 17 views 1 comment 0 points Most recent by David Tutwiler Formulas and Functions
-
Stuck SheetIn Using SmartsheetWe have a sheet which is locking up every time you open it. If we have it open, you cannot click on any other sheet or the home icon to get to another sheet or workspace. We have found that we can right-click another sheet and open in a …
