-
Show ONLY Tasks in a Date Range
Is there any formula and/or filter that will enable me to show only the tasks that are scheduled to happen during a particular 3 week time frame, much like a 3 week lookahead. I want to show tasks that, during the time frame, have the following criteria. Begin and End AND is INCOMPLETE OR Begin AND is INCOMPLETE OR End AND…
-
Add "active" email addresses into Dashboard
I have a list of project team members on the Dashboard. Is there a way to show email address that will create an email when "clicked on"?
-
COUNT(DISTINCT(COLLECT - Counting a value per employee
Hi, I'm trying to count how many values I have for certain people. I have two values that are assigned to the employees daily, for each day we have a value of either "Y" or "N". I want to count how many "Y" an employee has. I'm getting this information from a big database, to have it summarized in a small one. I've tried a…
-
How to handle large projects
In this article, we show how to handle large projects by splitting the projects into subprojects while keeping coherence and synchronicity by linking cells between sheets as available in Smartsheet. This technique is safe and robust. The tracking of the project's progress remains fully automated. We have thus put the…
-
Hello to all. Will start sharing my experience soon
Hello to all. I am using Smartsheet since many years. So far I didn't share my experience with the community. This is about to change now. I plan to post regularly on these topics: - experience with Smartsheet in large industrial projects - tracking progress of projects - forecasting end dates of projects - using…
-
SUM of Hours column
Hello, I have four columns: Task | Hours | Assigned to | Total hours The 'hours' column is how much time (hours) it will take to do the task, the 'assigned to' you can assign the task for more than one person. Now I need the 'total hours' column to show me how much time it will take for a task (example: Task1 takes 1 hour…
-
Dropdowns in a dashboard, is it possible?
I have one sheet that has metrics for a few of my employees, I was hoping there was a way to get the drop down menu function for each employee transferred onto a Dashboard highlighting everyone's metrics. *The drop downs show their total sales for each month, and even quarter, down to how many projects they have completed…
-
Show multiple labels on the Timeline Display
Any column can be selected as the label on a bar in the Gantt Chart timeline display. It would be nice to have the option of selecting multiple columns to display. For instance employee and description, task name and cost, assigned to and budget remaining, etc. It would be helpful to be able to also designate the…
-
Charts Plotting 0
I recently contacted support to find out if there was an option within dashboard charts to keep the charts from plotting 0. I received the following response: Currently we don't have a feature in place that will prevent specific values from showing on the chart. At this time the only solutions that we can provide would be…
-
Linking Sheets in Workspace, Cell Pull through based on conditions
I am creating a series of sheets in a workspace. The idea is that there is one master log that feeds other logs as it is updated. The child logs would be fed once a condition on the master log is met, the kicker is that I don't want a line for line transfer leaving me with blank lines if a line on the master log has not…
