What can we help you with?

e.g. Gantt chart, Creating tasks, Sharing folders

Subtract working days only in a formula

3 comments

  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Hugh

    Hi JAy Ahluwalia, welcome to the Community!

    This is a very interesting question - could you share some more details around how you are doing this currently? I'll see whether I'll be able to help, it might be a good idea to ask our Advanced support for advice. I can raise a ticket for you from here ๐Ÿ˜Š

    Let me know what you think, looking forward to learn more on what you're trying to achieve!ย 

    Hugh Community Team at Wrike ๐ŸŒŽDiscover... Wrike Discover and become a Wrike expert. Click here to get started

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Jay Ahluwalia

    Hi Hugh, this would be great. We are trying to implement our shipping project plan in Wrike. So if a customer asks for an item on Wed and it take us 5 days, we have added a custom date column (Wed Date - 5) hoping that it tells us to start the job on the previous Wed (5 working days) and not Sat (5 days). Then we have a calendar showing timeline between start date and due date. This would be very helpful to us.ย  I am sure it would be very helpful to your other users also. Thanksย  ย 

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Hugh

    Hi Jay! I understand what you mean now.

    When are you setting up your tasks and choosing dates, be sure to select the "working days only" option in the date view. Then, for a custom field, create a field titled "Custom Date" and set it up as a Formula custom field. If your formula is [Due Date]-[Duration], it will give you a date in your work schedule that will give you a starting date for the task!

    Hope this helped! If you have any other questions let me know ๐Ÿ˜Š

    Hugh Community Team at Wrike ๐ŸŒŽDiscover... Wrike Discover and become a Wrike expert. Click here to get started

    Is this helpful? 0
    Comment actions Permalink

Please sign in to leave a comment.

Folllowing List for Post: Subtract working days only in a formula
[this list is visible for admins and agents only]

Community

Welcome ๐Ÿ––

Hi there! ๐Ÿ™‚ Want to become a black belt Wrike Ninja? Here's how to earn a Wrike badge

Welcome ๐Ÿ–– Have you checked out this week's Release Notes yet?

Hey! ๐Ÿ‘‹ Curious about something? Visit How To to search and ask the Community for answers.

Welcome! ๐Ÿ‘‹ Figured out a good tip or trick? Share it in Best Practices.

Want to connect your existing software to Wrike? Learn and ask how in the API section.