T Minus Weekly View - Formula or Automation?

Options

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!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!