Como podemos ajudar?

p.ex. Gráfico de Gantt, Criar tarefas, Compartilhar pastas

Blog

Create a formula in Wrike Analyze for Task Duration (work days only)

2 comentários

  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Hugh

    Hi Olivia!
     
    Currently, there is no way to exclude weekends when calculating the duration of tasks in a formula. One possible workaround could be to use a CASE to specify that if the ddiff between the dates is >7, multiply by 5/7. This won't be precise, but it will give a duration that is more accurate than one including the weekends.
     
    Hope this helps! If you need anything else, let me know.

    Hugh Community Team at Wrike 💡Aprenda sobre as funcionalidades e melhores práticas em Wrike com o nosso Treinamento Webinar Online

    Is this helpful? 1
    Ações de comentário Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Olivia

    Thanks so much, Hugh, for this clever workaround! I will play around with it and see how it goes. :)

     

    Best, 
    Olivia

    Is this helpful? 0
    Ações de comentário Permalink

Por favor, entrar para comentar.

Folllowing List for Post: Create a formula in Wrike Analyze for Task Duration (work days only)
[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.