- 尽管th看不到数据报告吗at there is data on the form, what is wrong?
Since days ago I can't see anymore the Data of my active project report, despite that the project intake sheet has the information. I try to create a new report, also try to filter again, to make a copy of intake sheet and create a new report, but nothing works Help
- Copy/ Paste Cells With Multiple Lines Doesn't Work
I've been digging through community for resolution to this issue, but I'm coming up empty. I need to be able to copy/ paste multiple rows of data that have "multi-row (alt+enter)" information from Excel (and Smartsheet). Currently, when I try to copy and paste these "multi-row" cells, they spill into separate cells instead…
- Project Sheet - Static Finish Date
I didn't see a post about this yet, please post a link if this is a repeat issue! It seems like the default relationship between Duration, Start, and Finish is that when you update the finish date or the duration, the start date is kept static, the duration gets extended and the finish date gets pushed out. Is there a way…
- 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…
- Is there a way to have a column automatically pull data from multiple columns based on the month/yea
I have a master sheet that includes data for multiple projects from different months. I'm trying to generate a column that pulls the data from the current month. The intent is to create a cell that populates automatically and can be referenced on a dashboard. I have tried to use the index/match formula with no success. I…
- Constraint Types in Gantt View
Requesting the ability to use constraint types in a project (Gantt view), similar to the options in MS Project: As Late as Possible As Soon as Possible Finish No Earlier Than Finish No Later Than Must Finish On Must Start On Start No Earlier Than Start No Later Than
- Multiple Critical Paths in Single Project
The last task/activity in my project plan is not the "end" of the project, or at least not the end that we care about for reporting purposes. I work in pharma, and our project sheets are tracking toward their NDA submissions, which is the "end" of the project that everyone cares about when it comes to executive reporting…
- Health Bubble Turn Colors when Status is Updated
Hello, I am new to Smartsheet. I am trying to get when I change my Status to "Not Started" I want the Health bubble to automatically turn grey. And when I change my Status to "In Progress" the Health bubble will turn yellow, etc. So far I have: IF(Status1 = "Not Started", "Gray", " "). I want it to change color for each…
- Restrict a Checkbox from Getting checked (With out Using Dependencies)
Hello, I'm trying to restrict a Done checkbox from getting checked before other boxes are checked first. My team created a project plan with multiple steps in the process. Each step has a done checkbox. I have a formula that fires when a specific box is checked but don't want folks to check that off sooner than they…
- Pre-populate a form
I am building a change control log. Is it possible to pre-populate a form with cell data from a sheet? For example, project name, ID, customer, description and resource from the sheet to help the process of logging a change to the change control log.
