-
Hyperlink the numbers in the dependency column (Predecessors)
It would be great to have the numbers displayed in the dependency column (predecessors) as hyperlinks to the rows.
-
Merged: Support for Date Time format
This discussion has been merged.
-
Email Alerts for Multiple Rows, Individually
Is there a way or setting where I can control how email alerts are sent when multiple rows match the criteria? For a while, even if multiple rows matched the criteria, we would always get individual emails/alerts for each row. (i.e. 6 row match criteria = 6 emails). However, after the recent update, I now only get 1 email…
-
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…
