Hi! This one might be tricky... Help with T-Minus Formula *First time posting!*
Hi! I am basically looking for a formula that will return me a "T-2" result.
For example, a product is launching on 12/31/2025, and XYZ activity is taking place 01/31/2025. Ideally, the formula would tell me it's T-11 from the launch.
Does anyone know how I could solve for this?
Answers
-
Hi @LeeAnnS
You can get this done, but you'll probably need to make two columns to capture the year of the start date of the task and the year of the final end date, provided it is just the month lapse that you're looking at. Once you've them, you can write this formula to get the result you need.
="T - " + IF([Year of the final end date]x > [Year of the particular task]@row, 12 - MONTH([Date of the particular task]@row) + MONTH([Date of the final task]x), IF([Year of the final end date]@row = [Year of the particular task]@row, MONTH([Date of the final task]x) - MONTH([Date of the particular task]@row)))
Substitute x with the row# of the final task's date. If the final task appears in row 30, the formula will read [Column name of the date column having 12/31/2025]30
Date of particular task refers to the date of XYZ task in your example
Year ones are the new columns you will create to capture the year of each task and the year of the product launch date
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!