Formula for a Due Date

Sirius_200
Sirius_200 ✭✭✭
edited 07/14/22 in Smartsheet Basics

My goal is to make Smartsheet calculate an End Date for a task.

The End Date of this task depends on these two variable:

Variable #1: 100% Project Completion Due Date

Variable #2: Duration of the Project

The End Date for this task is half way to 100% Project Completion Due Date.


What is the best way to make Smartsheet calculate this End Date?


I think there are two possible methods for me:

Method #1: Use "Predecessors"

Method #2: Use formula in "End Date"


But I don't know how to use "Predecessors" and formula in "End Date" to make this work.

Does anyone have a suggested solution?

Answers