-
URGENT! Account access terming! How to offload/archive data for access outside of Smartsheet
I urgently need your help! My employer recently sold my division and I just found out that we will be removed from the original enterprise account as of March 1st. I've built a complex toolkit based on the PMO Office template and use Control Center and Dynamic View add-ons. This toolkit contains data that is subject to…
-
Moving a project to another blueprint in Control Center
To setup Control Center Portfolio WorkApps, you have to start with a new blueprint. Short of having to re-spin up assets, it does not appear there is a way to transfer a project from one blueprint to another in Control Center. For Example - you have Blueprint x that pulls from Intake and outputs to Master Project List. To…
-
Lookup with #NO MATCH error
I've used the Lookup formula to find hours per work order number. Until today, the formula reported "0" in the event the lookup value was not found. As of either Jan. 17 or 18 (today), it now reports "#NO MATCH" when the lookup value is not found. Did something change recently with the way this formula works?
-
Card view sub tasks, can't see sub tasks of sub tasks
Card view is excellent, so good, was about to run my whole company of it!, however I have hit a snag – In card view you can view level one and its subtasks – good, however I now cannot see the subtask of a subtask, you cannot even see if there is another level below. Ok so you go to view all levels, which is fine but you…
-
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), " +…
-
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…