Week number in custom field

[Daniele14]

Hi all!
First post as an Asana Ambassador here so please don’t be hard on me

I’m asking if there’s a way to build a custom field in a project where the date is shown as week number. I’m thinking about the advanced functions, because I can do that with a numerical custom field (just WK1, WK2 ecc.), and using rules to automatize it (like show Jan 05-11 as WK2) but then I’ll have to re-do it every year and that’s not fisible.

Any idea?

[Zaki_Imtiaz]

Hi @Daniele14 ,
welcome to Asana community. I have worked around your query and come to a solution but for implementing this solution you would need automation tool(i.e zapier/make.com).

Let me tell you step by step;

1. Create a custom number field in your project named “Week Number”.
2. Use Zapier or Make to create an integration with Asana using the following logic:

• Trigger: When a task is created or a due date is updated in Asana.(You can choose the trigger you want to apply )
• Action: Calculate the week number of the year using the task’s due date.
  • Use the WEEKNUM function built-in functions in Zapier/Make.
  • Example Logic:
    • Jan 1–7 → W1
    • Jan 8–14 → W2
      As the result of this automation the “Week Number” custom field gets updated in Asana automatically.

Zaki

Business Workflow Consultant

[Daniele14]

Hi Zaki! Thank you very much for the solution, I’ll definitly try this one!