- Build Hours/Cost Estimate Tool: Reference Entered Text Value from the same Colum in a Column Formula
I want to make a cost/hours estimating sheet that will sum the hours or cost of the children rows, but I want the cells with a hierarchy level of 1 to allow users to enter their estimated hours. Can I use an SUMIF statement in the column formula but have a mechanism that allows values to be entered in cells with the…
- Lead and Lag start time columns
Any clever hacks to have smartsheet show the leading and lagging start dates according to multiple predecessor relationships?
- Return Maximum value of a column, but only from Child Rows.
I want a column formula that will return the maximum value of values in another number column [Inventoried Qty], but only assess the values in that column from child rows.
- Reference Cell by Relative Location in a Column Formula
I need a means in formula, that would be used as a column formula, to reference a cell using its relative location...like an "@row-1". Is there a way to do this in Smartsheet?
- Change Predecessor Dependencies in Report
Dependencies in the predecessor column in reports are not viewable but I need some capability for users working from the report to update lag or lead days. If the row that is being viewed in the report is not the leading task in a line of dependent tasks, the user is only able to update duration (not the start date, finish…
- Content Sized to Widget Box
The chart inside the widget field is not scaling to the field and condenses some aspects of the chart if I bring the field boundaries in, but will not expand larger than seen below. The "scale data" selection in the horizontal axis is grayed out, I cannot select it. And changing the font sizes does not expand the overall…
- Card View for Reports in Smartsheet Gov
Hoping this is easy- Card View for Reports seems to already be available in Smartsheet. I'm working with Smartsheet Gov and it is not yet available. Please add to smartsheet gov.
- Smartsheet Report Builder
When setting conditions to build reports, I have found on multiple occasions in the "What?" parameters, I have needed to specify more than three conditions that need to be treated with different boolean operators...ie. return rows that have "QA/QC" specified in auto assignment OR have "QA/QC" specified in Production Status…
- Build a Burn Rate Formula
Here is a puzzle I'm struggling with, would like to make a burnrate that distributes the total labor expected across the task period of performance. It does this by dividing the labor cost ($), by duration (work days), then multiplying that by the rate by the number of work days scheduled for the task in a month period. I…
- Filter View to Hide/Unhide columns
I have many, many columns on one product, its good they are all there but its unwieldy. It would be perfect to have filter views that could be selectable by columns, then I could switch views to look at groups of distinct columns that show burnrate, or cost estimate, or project progress. Any better option beyond manually…
