I need help calculating days btw 2 tasks
I need help basically calculating lead time for a portion of a project.
For example to Calculate Planned days I need a formula that would subtract the date the Samples where approved from the date the Mass Production is scheduled for delivery. So the formula would calculate something like this: MP Receival - Golden Sample approved
Comments
-
You should be able to just reference those cells.
So if Mass Production is on row 3 of the [Date Column] and Golden Sample Approved is on row 12 of the same column, it would look something like this...
=[Date Column]3 - [Date Column]12
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi Paul,
Thanks for the feedback, this is really helpful.
I have a question. On what column would I enter the formula?
Should I insert a new column for Text/Number where this would be calculated.
-
It depends on your setup. Are you able to provide a screenshot with sensitive/confidential information removed, blocked, or replaced with "dummy data"?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi Paul,
Here's a screenshot
-
I would suggest a new text/number column with the formula in it.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Ok great. Thanks a lot
-
Happy to help! 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!