Formula on Target Date Column

KC0

Hi,

I am trying to create a formula in Smartsheet that automatically calculates the target date for a task based on the “Go Live Date” and a “Weeks Prior” value.

For example:
Go Live Date column has 08/02/2026

Weeks Prior column has 12

I want the Target Date column to automatically calculate the date that is 12 weeks before the Go Live Date.

Could you guide me on how to set up this formula?

Thanks

Paul Newcome

Try somethign like this:

=[Go Live Date]@row - ([Weeks Prior]@row * 7)