-
merge two sheets
Dear brains of Planet SS, I have added 13 columns (some with dropdowns etc) to an existing Sheet and now want to add these new columns to another five sheets. is there a quick way of doing this please? I know rows can be copied to an existing sheet, but what about columns? I was thinking that if i created a new sheet that…
-
Calendar View in Insights?
Can anyone tell me if there is a way to include a report that is using the calendar view in Sights? When I add my report, it only shows the Task Table view and not the Calendar view. Appreciate any thoughts or suggestions. Thx!
-
Best or Easiest Way to Report on Milestones or Summary Tasks?
I know that SmartSheet can distinguish between tasks that are regular tasks, or milestones, or summary tasks (because of how it represents them on a Gantt chart), but how can I leverage this information when I am trying to build a report on just milestones or just summary tasks? Is there some way to tell a report to filter…
-
Rule Creation Help Needed!
Hello - I am managing a Smartsheet action item log. I need any row that is deemed 'complete' to be moved down into a completed section further down the sheet. Is there a way to set this up to be automatic vs. manual?
-
Non-working days are no longer greyed out - Bug?
Hello, We have recently begun working with Smartsheet and we detect that nonworking days are only greyed out when the setup gantt menu is openned. Is there a bug in our system or a configuration is needed? It occurs with a single new project without changing anything. We have seen a similar discussion but without…
-
Gantt view by project days, not dates.
Question, I am trying to create a Gantt chart that tracks a project in terms of days, not dates. For example, Task 1 will run from Day 1 to Day 5, Task 2 from Day 3 to Day 9 (instead of August 3rd- August 8th). Is there a way to do this?
-
IF Match formula failing. Can you use Children as the test to search?
=IF(FIND("Fail", (CHILDREN([Subtask Status]231))) > 0, "Failed Subtask", IF(Column231 = 1, "Pass", IF(Column231 = 0, "Not Started", IF(Column231 > 0, "Review In Progress", IF(Column231 < 0, "Review in Progress"))))) The above formula is returning #Invalid Data Type I also tried to break the formula down into two parts to…
-
Working Instructions
Hello, Happy Friday! Some column headings that i have set up could benefit by having additional instructions pop up to aid the person completing the sheet with best practice. can this be done please?
-
Report not picking up all checked Star symbols
I am running a report and using a Star symbol to filter what should be picked up from my sheet. The report is picking up all rows with stars checked except one. I have confirmed this row is checked. I have removed the Star filter to show all data and it works just fine, picking up this row. But when I go back to filter by…
-
Need help with a formula
here are the formulas and a look at the Spreadhseet. The Column labeled Column has the following formula =SUM((COUNTIF(CHILDREN(Passed10), 1) / SUM(COUNT(CHILDREN(Passed10))))) The current formula in the Status column for the Exception Rules row10 is =IF(Column10 = 1, "Pass", IF(Column10 = 0, "Not Started", IF(Column10 <>…