-
Merged: Kanban Grid
This discussion has been merged.
-
Project status synchronization between 2 sheets
I have 2 sheets (2 project trackers) and need to present the status in a "master" tracker based on a data from the "slave" one. The problem is that in the slave there could be couple (even 20) rows that are connected to the one project in the master file. They are connected via Project Name column. I need to somehow merge…
-
Auto Refresh for Reports
I'd like to request Smartsheet look into adding the "auto-refresh" feature, currently only available on Dashboards, to Reports. We use reports to filter columns for individuals in teams that share a sheet, but who don't need to see all the columns on that sheet. This works well, except the user is forced to save and…
-
Formula to countdown contract expiration dates
I have a sheet that lists all active contracts for my department. The sheet houses the contract details such as Contract Name, Contract ID #, Vendor, Start Date, End Date and Extension Date, etc.… I am currently using =[Expiration Date]@row - today() as the formula in an adjacent cell to countdown the days until the…
-
COUNTIF with Parent rows only, exclude children
I want to create a COUNTIF function that will count only the Parent row of a status column in a project tracking sheet. This is to create a metric sheet that will show all project statuses by each project manager's sheet. There is a status column using Green/Yellow/Red/Blue identifiers, and children rows need to include…
-
Recording Week Tasks Were Completed
Hi all! I'm back with an old problem that rattled me a few months ago. Basically, when a task is completed, its date of completion is saved. For the sake of being able to a process this data in a more comprehensive manner, we want to take that date, and assign it a "weekOfCompletion". Another note, is that the weeks here…
-
Index Match (?) to two different sheets (unique values)
Hi - I am not sure what is the correct formula to use - I have tried a few and I get errors, so would appreciate some assistance. I have been using Cell Linking to pull in the data, but due to the volume it has become cumbersome and unreliable. I have a master project plan with unique Site IDs in the primary column, and…
-
how to build Gantt with dependencies
Hey, We are R&D company developing large-scale capital equipment. I've built a very detailed Gantt and need help with the central issue of blocking other parallel tasks. We have many different projects on the same machine and machine time is the most valuable asset in the company. How do I block other tasks when they…
-
Formula to count the overdue task with Assigned Person
To brief, need a formula to know the overdue count for each assigned persons. With these details, will help show a chart in dashboard