-
Creating/managing daily task lists
I'm new to SmartSheet, which my team has started using to manage collaborative projects. I'm trying to figure out the easiest/best way to generate a daily task list for myself drawing from the sheets I've created for the multiple projects that I manage. Your suggestions are most welcome!
-
SUM IF & LEFT @cell
I keep getting the result of 0 I am trying to sum a range if another column contains "Street Lighting" I have tried changing the text reference from the entire column, to particular range and adding the LEFT @cell with and without #(5) see below. =SUMIF(Team:Team, LEFT(="Street Lighting", [Days to respond]2:[Days to…
-
System Improvements for August 19?
I may have missed this somewhere, but I am curious what enhancements are slated to be implemented this weekend--August 19? Looking forward to some awesome new functionality! I appreciate any insights... Steve
-
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…
-
Report - Finish Dates
I have a report I use which gives me all tasks in my projects that are overdue, due today, or due tomorrow. (A screenshot of the report builder is attached, below.) It stopped working properly yesterday, when I updated some dates but the task did not drop from the report. Today, it's showing tasks that are due a week from…
-
Locked columns
When you lock a column, is the person that created the form the only person that will be able to update that column? I have a column that I want one of the people that I will share the report with to be able to edit the column.
-
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?
-
SUMIF not working properly
I am trying to create some summary totals on an inventory sheet. We stock several model Laserjet printers. Each row has it's own sum. Now I'm trying to create an overall sum of Laserjets by using the following formula: =SUMIF([Inventory Item]1:[Inventory Item]86, "Laserjet", [In Stock]1:[In Stock]86) If I interpret how…
-
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?
-
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…
