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.

何かお困りですか?

ガントチャート, タスクの作成, フォルダーの共有...

Subtract working days only in a formula

3件のコメント

  • 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 💡Learn about Wrike’s killer features and best practices with our Online Training Webinars

    これは役に立ちますか? 0
    コメントアクション 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   

    これは役に立ちますか? 0
    コメントアクション 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 💡Learn about Wrike’s killer features and best practices with our Online Training Webinars

    これは役に立ちますか? 0
    コメントアクション Permalink

サインインしてコメントを残してください。

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.