Construction
Discussion List
-
Automatic Children IndentingIn Using SmartsheetHello, 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 rat…
-
Zero FormulaIn Formulas and FunctionsWhere do I find the formula to have a cell display nothing when the total becomes the number zero? I have a sheet with zeros in multiple places and it clutters to much.Answered - Pending Review 1.8K views 34 comments 0 points Most recent by BenG0706 Formulas and Functions
-
Time Tracking - Hours and MinutesIn Formulas and FunctionsI was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-ar…
-
RTF in Dashboard WidgetIn Using SmartsheetI downloaded an example dashboard which tracked multiple projects. Looked good and decided to build my dashboard to match example. Example dashboard has a Rich Text Widget which has multiple formats within. However when I try to use the…
-
Kanban View - printing or saving to PDFIn Using SmartsheetIn the Kanban sheet, can this be saved to PDF in card view or printed in card view ? currently it shifts to list view when printing.
-
Start and end date line chartIn Using SmartsheetHi Team, Can anyone help me how can I create a line chart based on below information. I
-
If and FindIn Formulas and FunctionsIf cell A3 contains "ABC" then enter "ABC" in cell A1. Can someone help me do this in smartsheet? I tried using =If(find("ABC",A3,)="ABC","ABC","X") but its not working. …
-
Update Columns in Existing Row Using FormsIn Using SmartsheetHello, I have a sheet where I am tracking construction progress. There are a lot of data/calculations that my field personnel do not need. I want a simple interface for them to update data (% Complete, Actual Date Completed, etc.) Each…
-
Dependency Logic based on one or the other predecessor tasksIn Formulas and FunctionsIs is possible to create schedule logic where a dependent task is dependent on one of two predecessors (either or not both)? For Example: I am trying to build out a schedule template for if a permit is required vs not for a specific projec…Answered - Pending Review 47 views 1 comment 1 point Most recent by Genevieve P. Formulas and Functions
-
Rows will not stay in place. NEED HELP NOWIn Using SmartsheetWe use a sheet as both a schedule and data collection tool as part of a much larger system we just put in place (literally 5 days ago, moved from google sheets). The information is organized manually first by employee and second by the pri…