-
Milestone Duration Not Calculating Correctly
When putting milestones into a project plan, the duration is calculating as "1d" instead of "0" like it should. I cannot figure out why this is happening. Can anyone please advise?
-
Can I automatically adjust predecessor dates by changing the dependent date?
I'm looking to create a dynamic project schedule with the functionality described below and would appreciate any help from the Community! Our dependent task end date changes rather frequently based on shifting priorities. I would like to change the final dependent end date (in this example, 'swim') to 3 days later (9/10)…
-
Hlookup Help
Hey, I have a formula currently in a spreadsheet that is an Hlookup, and I am super stuck recreating it in SmartSheet. I have tried the index match, but it is still not working. I have it attached but basically, I have 2 factors "likelihood" and "impact" that drive the "severity". There is a table that says what the…
-
Deleted Rows
RIGHT NOW: Implement a pop-up warning to alert someone and verify that they want to delete a row. You do it for unlocking rows, and that's nothing compared to deleting a row. SOON: Give us a new user level with edit access but no ability to delete rows or make it impossible to delete a row if any cell in that row is locked…
-
How to do a cumulative running count of a value in a column
I need to count the number of times a value occurs in a column and have it do a running count of it in another column. Example: I have a spreadsheet with a column (B) that will have numbers that will occur a varying number of times. In another column (A), I want it to count the number of times that a value shows up in…
-
Trying to convert a form to smartsheet and having problems
Hello and Thank You in advance for any guidance you may be able to provide. I'm trying to convert a form that i use to track FTE changes into smartsheet. What I need to have is a section that allows for multiple responses for each type of FTE (Admin, Clinical, Educational or Research) some that might be the same (for…
-
Dashboard Line Chart - Automatically Update
I have a Dashboard created with a Line Chart in place that plots simple data points 'as of' a certain date. I have a Data Shuttle that updates the source sheet each Friday with a new data point. Is there a way to get the Line Chart to automatically recognize that a new row / data point was added to the source sheet?…
-
Summary across sheets
I have two work plans with folks assigned to tasks and want to be able to see how many tasks on each sheet the person has assigned to them. For example (not in terms of formatting) Person A: Sheet X=# | Sheet Y =# Person B: Sheet X=# | Sheet Y =# I have a report grouped by person that has both sheets feeding into it but…
-
sheet summary report not counting multiple different responses given in one cell
Hi all, I have a summary sheet report with fields drawing responses from surveys collected. The surveyed people were able to tick several possible answers in the surveys. These multiple responses appear in one cell, e.g. "how did you find the event?" and the answers are "fun, educational, accessible". I would like the…
-
Intake data-> Project Sheet...Why so difficult????????????????????????
All I want to do is take what's in a row in the intake sheet and have it populate into a column in the project sheet. I feel like I'm making this too difficult, but after much review of previous helpful answers in this community, I still have issues I can't solve. Hoping you all can help. Issue 1 Index match gives me the…
