Week number in custom field

English Forum Ask the Community
,
1

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

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?

2

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

3

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