Connect Action log (dates) with a project sheet dates

Nico Abreu
edited 12/09/19 in Formulas and Functions

Hello;

I am currently working with two sheets, one is the project plan and the second one with an action log corresponding to one of the phases of the plan.

 

I have an issue when I am trying to connect log date & due date of each of the actions of the action log, with the finish date of some of the activities from the project plan sheet.

The reason why I would like to have it connected is that I have a full plan with all the dependencies created which I want to extend to this sheet.

I have added a screenshot to illustrate what I am trying to achieve and the issue that I am facing.

Thx a lot.

Regards.

Nico

 

_1__Workshop_Action_Log_-_Smartsheet_com_and__1__V1_Project_Plan_-_Smartsheet_com.png

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!