Task dates

Chichi

Chichi ✭✭

04/09/20 in Smartsheet Basics

Hello,

Is it possible for me to create new tasks that has a starting date tied to the end of one task, and a finish date tied to the end of another subsequent task?

Thank you

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

04/09/20

You can do this using predecessors if you have dependencies turned on. If you do not, you can use cell references in formulas.

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Date Formula Help Needed!
My current formula seems to count weekends and then also seems to count the day of as a day too - can someone help me rewrite this so days until due for 1/17/2025 would show as 1 and not 2, and then also skip weekends? Formula in case its hard to see below - =IFERROR(NETWORKDAYS(TODAY(), [Reporting Due Date]@row), "")
Retrieve value from "Top Parent" when Ancestor level = 2
I have a project management sheet. CSYYXXXX is the header for the project name column Tasks is the tasks column - at the parent row, I just write "Tasks" and then there are child rows below that. Some of these child rows and another level of descendant rows. I want a column formula (to serve as a helper column for various…
Target Date/Delta info vs Baseline in PMO plan template
Hello! I've read through several past posts related to this but couldn't quite find my answer. We are using the PMO plan template and have activated the baseline feature. My manager has asked if there is a reason to keep the Target Start/End date columns as well as the related Delta columns since they're basically the same…

Help shape the future of Smartsheet.
Share your ideas and feature requests.