Hello. I'm pretty new to Smartsheet and can't find an answer to today's dilemma. For example, I have a two sheets: ABC Project (belongs to me) and XYZ Project (belongs to our vendor)
I want to be able to calculate a start date on one of my tasks in ABC Project by pulling a finish date from XYZ Project?
Basically like this: (I know this doesn't represent an accurate formula)
- Finish XZY Project task line4 - 10d = Start Date Project ABC task line 5
I don't want to include project XYZ dates in my sheet, because it'll make our start date look earlier than it actually is.
Thank you!