-
Merged: Easily create recurring tasks
This discussion has been merged.
-
Task hours spread over a week
We work in a digital marketing agency; with individuals working on multiple tasks across multiple days. How can we spread an 8 hour task over a 5 day week without restricting the task to one day and without creating 5 smaller tasks for each day (as priorities may need to change due to emergency escalations) For example:…
-
How do I make my Smartsheet columns update when I update the Form
I'm brand new to Smartsheet Forms and I'm on deadline. I accidentally created a Form tied to the wrong Sheet. After realizing my mistake, I duplicated the original sheet and fixed the new column headers (which had populated when I created the Form, of course!) and went back to the original incorrect Sheet ... I THINK it's…
-
Merged: More flexible Gantt and Timelines
This discussion has been merged.
-
Duration Including Weekends
Hello! We have our project (task tracker) set to exclude weekends, which is what we need as we don't want anything due on the weekend. However, we need a duration column that includes all days between the start and end date, not just the business days. How can I do this? It's currently showing the duration of business days…
-
Float between task and it's successor
Hi, There doesn't seem to be any clear way to calculate the float between two tasks. If I have task A and task B, and task A is a predecessor to task B, I'm looking for a formula to calculate the amount of time task A can be delayed. Has anyone found a method to do this? TOTALFLOAT is not useful on my projects, it often…
-
Trying to create a formula that determines the current season
I've got a formula that generates the current quarter and one that calculates the current year. Now I'm trying to write an IF statement that creates a value that says S23 by reading if its Q1 or Q2 and then adding the 23 from the current year (2023). This is my current formula, can anyone explain why it's not working or…
-
Indexing across sheets with the same name
Is there a way to Index or search all sheets named Project Metadata? I want to populate a sheet using the project number at the top level.
-
Control Centre - Batch Updating
I am about to launch my first control centre Blueprint and one thing I am wondering is what would be a best practice for recording notes at a program level. We have a status meeting that reviews the projects in the Blueprint Summary.. The client will pass on a tidbit of knowledge in the meeting and we will record a note..…
-
Program Management: Metrics for RAID Logs
Hi all, I am working to mature one of our programs by creating a dashboard that encapsulates several types of metrics, but one set of metrics I'm struggling with is our RAID Logs. I am using a Smartsheet Blueprint to spin up our projects and each project has it's own RAID Log to track against. I'm hoping to hear of how…