-
New to Smartsheet - Project Management
My company uses Smartsheet, all jobs for the entire division are loaded into one sheet (tasks, deadlines, completion dates, etc). I am new to the company, and have never used Smartsheet before I am responsible for about 1/3 of the projects in that sheet. All I want is to be able to pluck from that "master sheet" the…
-
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…
-
Use cell history to calculate task delay
Hi, I am new to Smartsheet hand have been trying to find an answer to this without success. If I look at examples to track delays for tasks I always see folks adding extra columns like the actual start and end date to calculate the delay. I guess it works but I was wondering why that's required as you have the original…
-
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…
-
Could anyone help us create the proper formula? Parent/Children Health based off Due Dates
We are trying to utilize Smartsheet to list out, follow, and forecast our project schedules. The idea is that each Milestone of the Project is the Parent and the steps within the milestone are the children. We are having issues with the parents correctly representing an issue/delay within its children. Right now the…
-
fixed durration vs. fixed start/end dates (deadlines) with gantt chart
I'm trying to develop a template for scheduling the 30 to 60 sub tasks in each of the many year long projects I'm managing. Im hoping to use a dashboard to tack all the projects at once. but for the template id like to set up an easily adjusted Gantt calendar. There are dates that are subject to fixed dates like quarterly…
-
Looking to compare two dates to create an Integer value across sheets
Hello, I am looking to create a tracker that tells me the quantity of samples that arrived in the estimated time against the actual time. My thought process was you have two date columns Date Column A (estimated date) and Date Column B (actual date). I would in my raw data sheet create a link to Column B first than compare…
-
Resticate access for Managed licensed users.
Hi team, In our organization, I pool out allocation reports for every month which I used for monthly billing and financial work. So at the last of every month when I generate the report that time I am aware of everyone not to change any allocation without my permission, but here number of project owners we have, we couldnt…
-
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"?
-
Scheduling 30-60 task annual projects with just 200 whole working days per year
I want to develop a template sheet that I can use to easily schedule out 30 to 60 different 30 min subtasks evenly over 200 specific available work days each year. I started out trying to set up a gantt view row with "200d" working day duration then removing sat/sun, and inputting 62 other Non-working days in gantt view…
