-
Due Date vs Traditional Start-End Dates in Gantt charts
I've used the Gantt chart functionality to good effect, although it seems to be a little too "smart" when you set up dependencies, durations, predecessors, etc. What happens is the dates get too rigid and "calculated", imo. So I'm doing a basic list of tasks for a 3-person team. Most of the tasks are not linked by 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…
-
Sights: Revision Control/Tracking History
I am attempting to migrate & automate parts of my company's business process of creating and updating weekly, project slide updates to incorporate Sights (since we use underlying sheets for project tracking). Are there any best practices, solutions, or workarounds for revision control of Smartsheet Sights? I was hoping…
-
Combining COUNTIF and COUNT(CHILDREN) formulas
Is there a way to create a single count formula that will return the number of rows using two criteria? I need the number of rows with column A = Abby and column F = MONTH(@cell) = 2
-
Automatically add rows when report refreshes
I have a report that's running every day against a single parent row to grab totals. A few cells of that one, single, lonely row. I'm looking for a way to automatically copy the report's information into another sheet daily, that way, over a period of 1 week, 1 month, etc., we can see the changes in the totals. This is…
-
Feature Request: Ability to Modify the Working Days of Specific Line Items
While building out a Gantt or waterfall chart in Smartsheet, it is not uncommon to have some tasks that can only occur during a weekday while others can occur on weekends. It would be great if one could modify the working days at a more granular level, that is the ability to edit the working day property of each line item…
-
Date Formula dependent on text
Hi All, I am looking for a formula that can ideftify text in a column and convert it to dates. More specifically I need it to pick up a cell says "X" convert to today's date +30 days, or if it says "Y" convert to today's date +30? I have found a formula that works in identifying only one set of text: =IF([Project Name]34 =…
-
avoid the shared person delete my row
hi, i see some potential of lose of my data if shared to others. for example, my project schedule shared to partnes and they have to update the status, since they are editor and they can delete my row accidently, how could i avoid from this issue to be repeated?
-
Request - Allow Webform to update a specific row number
Hi, I would like to request the ability to enter a row number on a webform. And when the form is returned or submitted by the user. The information on the form is automatically filled into the specified row. I know contact names are entered as text and cannot be linked with the sheet, but maybe a row id is easier to…
