Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formula: Remaining Work based on Any given Date
Does anyone have a formula that will calculate the following:
Reaming = 194
Deadline = Sept 29
X = How many do i need to complete per day in order to make the deadline.
Note: X should change based on today's date
Thanks
Comments
-
Kal-El,
Here is how I solved this one: the formula under Comp / Day is "=Remaining1 / (Deadline1 - TODAY())"
Let me know if you have any questions on this.
Steve
-
How do I only include working days (M-F)?
-
How do I only include working days (M-F)?
-
Remaining11 is 194
Deadline1 is 09/29/17
My formula: =Remaining11 / (Deadline1 - TODAY())
My result were 13,8571, which I know is not correct.
-
Disregard User Error. However, how do I exclude weekends and just calculate M-F?
-
Kal-El,
To answer your question in the simplest way, I have done the following (as shown in the screen shot below):
- Insert a column to calculate the work days between today and the deadline, using this formula: =NETWORKDAYS(TODAY(), Deadline1)
- Revise the Comp / Day formula as follows: =Remaining1 / [Work Days]1
Let me know if that doesn't work for you. Sorry for the delay in responding to you.
Steve
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives