T Minus Weekly View - Formula or Automation?

brittneyzhang

Hi team, how do I create a formula or automate a t minus weekly view. For example if start date - finish dates are within these parameters: 10/31/22 - 11/05/22 then I would like the T minus column to show 29. 11/07/22 - 11/12/22 to show 28 in the T minus column. How can I set that up in Smartsheet? Thank you for all your help!

Ryan Sides

@brittneyzhang

Hi Brittney, do you mean you want the number of weeks between your launch date and the finish date?

=([Launch Date]$1 - [Finish Date]@row) / 7

-Ryan