-
Admin Authorise change
Hi all, would it be possible to add in a feature so i can select a column which allows people with editor permission to change. However before that change is locked in, an admin has to check and approve the change. One of the main reasons we use smart sheets is the ability to lock columns and rows which is fantastic.…
-
Merged: Timeline Headers on Gantt Chart
This discussion has been merged.
-
Trying to use Time Function to calculate how many days,hours,minutes
I am using this found in the functions list: But Error says #INVALID DATA TYPE. Is that because the columns i am referencing are cross reference formulas and not text/number types? SEE BELOW FORMULA AND SHEET: =DATEONLY([Pending Tech Response Date/Time Stamp]@row) - DATEONLY([Completed Date/Time Stamp]@row) + " day(s), " +…
-
More Gantt Timeline Display Options
Due to limited screen space, I find the available Timeline Display options either far too dense to be useful, or too expansive. I propose: more Zoom settings. my issue is really that the zoom settings correspond to the heading incremements. my usability issue would be mostly resolved with more zoom level granularity. more…
-
Card (Focus view for sprint interval)
"I believe a great built-in feature would be to introduce a settings option for the card view, allowing users to specify the number of weeks displayed. Currently, I manually adjust filters to focus on a 1-5 week view of our project team's tasks. This involves updating the filters weekly to reflect the desired time-frame.…
-
Automatic Predecessor Adjustment
Hey All! I have a question about how to have predecessors or just tasks in a schedule to automatically update when they are moved in the schedule. I am trying to create a production schedule for our Sheet Metal shop and it is created with the fabrication packages released from the Eng Dept. Sometimes the schedule needs to…
-
Consolidated Dashboard or PowerPoint
OK sleuths, this one is for you. We are an organization that loves powerpoint, and no matter what dashboards we create, a powerpoint presentation is typically still needed. We need a way to consolidate our project status in one easy document or dashboard. Is there any way to create the either of the two solutions below…
-
Exclude Current Row
I am working on a formula where my final piece needs to exclude the row my formula is in. My Current formula is: =MAX(0, (PARENT([FCB LAB]@row) - SUM(CHILDREN([Baseline Labor]@row))) / 45) Can someone show me how to exclude the row my formula is in when summing the children of the Baseline Labor? For further clarification:…
-
Making sheets from a sheet
I know how to copy info from one sheet to another sheet. My question is...I've created an Application form for my employees to fill out. Is there a way to set up where a new sheet is created for each applicant and copies their info to it also. Meaning...Joe Smith fills out my application - then Smartsheets creates a brand…
-
Predecessor - Successor "Inspect" like in MS Project
A big miss in Smartsheet is the ability to evaluate predecessors and successors to understand easily what other activities are driving the schedule dates. The predecessor box is missing the date columns. And while we can now add a Successor column and see successor line numbers, there should also be a box we can open to…
