-
Extract Cell History For Formulas
Hello, Is there any way to extract the Cell history to calculate formulas. What I am trying to do is create metrics off the dates in the cell history. I.E. if a Dropdown list column starts on July 1 with Value 1 and changes to Value 2 on December 10th then Value 3 on December 21st. I want to measure and tract the time…
-
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…
-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
-
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…