Remaining days automatically added to children rows
Hi,
I have been using this formula : =[Production Due Date]1 - TODAY() in a cell for my remaining days left for a due date.
it works great as long as i drag this formula in to added rows or added children rows.
What's the trick on getting this to work automatically in the entire cell no matter if new parent or children rows are added.
Best Answer
-
@Heather D thanks much :-)
Works great.
Answers
-
Hi @Alexander Sullivan ,
Try this:
=[Production Due Date]@row - TODAY()
Then right click on that cell and click Convert to Column Formula. That will make the formula automatically appear in that column on every row.
Hope this helps!
Best,
Heather
-
@Heather D thanks much :-)
Works great.
-
@Heather D is there a way to go even further and have this formula take out(or not count ) the non working Saturdays and Sundays?
-
Great question! For that, you would probably want to use NETWORKDAYS:
=NETWORKDAYS([Production Due Date]@row, TODAY())
This function counts the number of weekdays (Mon-Fri) between the two values listed in parenthesis - in this case, your Production Due Date and today.
-
@Heather D that seems to work as well :-) now why is it showing me a negative Value?
total beginner in the works here .
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!