-
Formula to change a cell's value if date is in the past and another column's value is not a certain
Hello there, this is my first discussion and I have a feeling this might not be possible, hehe. I would like the Status (a dropdown list column) to change to a certain value ("Complete") if the Date (a date column) is in the past and the Type (a dropdown list) is not a certain value ("On Campus"). Thank you so much!
-
Wish list for Smartsheet
Hi, I am new to Smartsheet, and I have been using it this last month to manage one of my projects. One of the area I wish there was some improvements and changes, would be the Update Request area: 1. Be able as Admin to change manually the status of the request, reason being, that I send request to my team over in India,…
-
Feature Request: Timesheets / Time Columns / Time Trending
What we want, is to be able to generate a daily or weekly report of how much time each person worked, and on which tasks. We need to be able to not only see the efficiency of the tasks, but also of the people. And if we can select a specific period of time, this would also be useful. I have a project where each row has a…
-
Detailed timing?
Hi Folks. I see that there have been discussions for years about a feature that still seems to be missing. Even if now the duration of an event can be determined pretty detailed, we still can't tell that it is supposed to start at i.E. "9:15am next Tuesday"! Did I miss something, or is this feature really not yet…
-
Best practices for managing offshore team task and schedule?
We need to overcommunicate and manage our offshore teams better. What are best practices in terms of tracking and managing ALL the schedule and tasks using Smartsheet? One master schedule containing the details of every task (which we want individuals to go in and update status with comment)? Or separate the schedule from…
-
Rolling Week View in a Report
We have a smartsheet with multiple rows of activities and column headers: "PSA Start" and "PSA End" dates. We want to build 3 reports that shows: (1) PSA End dates due in 0-2 weeks (2) PSA End dates due in 2-4 weeks and (3) due in 4-8+ weeks. Can this be done directly from the report or will I have to create calculations…
-
What's the best way to show Baseline Schedule when it's not available on the Gantt?
We are using the Baseline "workaround" by creating the Actual Start, Actual Finish and variance column formulas. What method has worked for you to compare the baseline to the actual since it's not supported in Gannt view? *already upvoted this feature!
-
Gantt View Shaded Rows
Whay are some rows in Gantt view shaded, others not?
-
Trying to Sum Rows of linked cells
I'm new to Smartsheet and struggling with a few things, one in particular is wearing me out. I have several rows of linked cells that pull number values from another Sheet. I'm trying to Sum total these linked cells but the basic Sum formula doesn't seem to recognize these numbers. If I remove the Link the Sum formula…
-
Lags and Leads - Proposed Enhancements
There are two elements to Lags and leads that I believe are greatly needed in Smartsheet Projects: 1 - Being able to use elapsed time in Predecessors i.e. +e6h for Paint drying time or +e5d for waiting for approval from external agency etc. 2 - The ability to use percentage % in Leads so that the overlap is based on the…
